Ok, I believe what I'm trying to do is not complicated and that I'm simply missing some sintax but I will have to explain in full what I'm trying to do.
So I've created two comboboxes in Sheet1. What I would like to do is make the listfillrange in the second combobox depend on the selection in the first combobox.
Example.
Combobox1:
Numbers
Letters
If i select "Numbers", the listfillrange in the second combobox will display numbers 1-10
If i select "Letters", the second combobox will display letters a-z
In order to do this, the code for the first combobox assignes the listfillrange of the second combobox using named ranges which i've created but this is where i get an error.
If cells(1,1) = "Numbers" then (cell A1 is linked to the combobox and displays the same value)
ActiveSheet.Shapes("ComboBox").Select
With Selection
.ListFillRange = "I would like to insert the named range here"
End Select
What the proper syntax here, I've been through forums for hours. (Note: I need to be able to call the named range even if its not on the same sheet as the combobox)
Please Help
Thanks
Bookmarks