Is there a way to assign a macro to a Combo Box (Form Control) automatically, via an Add-In, when the file is opened.
Assuming "Drop Down 1" exists. Tried the following in the Add-In.
Private Sub Workbook_Open() Sheet1.Shapes("Drop Down 1").OnAction = "C:\Users\me\AppData\Roaming\Microsoft\AddIns\MyAddIn.xlam!Macro1" End Sub
You cannot use a sheet code name (Sheet1 in this case) to refer to a sheet in a separate workbook. Sheet code names can only refer to sheets in the same workbook that contains the vba code. This applies to add-ins as well.
Use the sheet name or index number or ActiveSheet.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I tried both of these but get error: run time error 1004, Method 'Sheets' of object '_Global' failed.Use the sheet name or index number or ActiveSheet.
Is it possible to remove reference to the sheet?
Last edited by Un-Do Re-Do; 09-08-2018 at 12:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks