It was suggested in a response to an earlier post that I could use a range to set the ComboBox List property:
I'd like to use a named range to set the ComboBox list. But when I try:Please Login or Register to view this content.
(where RangeName is a dynamic range name), I get:Please Login or Register to view this content.
Run-time error '381':
Could not set the List property. Invalid property array index.
Why can't I use a dynamic named range to set the List? Is there any way to fix this? I've searched in vain online, and every example I can find simply shows the AddItem method being used to add single items of plain text (like "Bananas"). No examples of using named ranges! Help!
Oh, and as a follow-up, assuming I can figure out how to get my ComboBoxes properly filled (using my named range), if I then want to remove whichever item was selected in ComboBox1 from the list of choices in ComboBox2, can I use:
or maybe:Please Login or Register to view this content.
or maybe even simply:Please Login or Register to view this content.
(I realize that the above would have to be in something like the ComboBox2_Click event, not in the UserForm initialization)Please Login or Register to view this content.
Bookmarks