I am getting an error ("Could not set the list property. Invalid property array index") assigning the list property of a combobox to a named range.
Please Login or Register to view this content.
I am getting an error ("Could not set the list property. Invalid property array index") assigning the list property of a combobox to a named range.
Please Login or Register to view this content.
Last edited by Jenn68; 02-01-2019 at 11:53 AM.
Try
Depending on the shape of ai_typelist, you mgiht have to Transpose the .ValuePlease Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
That worked Mikerickson! Thank you.
What's odd about my question, is that I'm cleaning up my existing VBA project which worked without error (it just wasn't very efficient) and my original line did work in populating the combobox without the extra code. Fluke?
Anyway ... it works which is all that matters.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks