Hi again to everyone! Hope everyone is doing well.
I am currently working on some macros, and, in order to facilitate input to the macros, I would like to use an "ActiveX" "ListBox".
So, I have created it by choosing "Developer"->Insert->"ListBox (ActiveX Control)", and have modified some properties, as I would want to have them.
Now, however, I would like to insert the "items" into the "ListBox". However, I would definitely "prefer" to enter them directly INTO the ListFillRange Property, in the "Properties Window" of the box.
I have tried entering, into the property:
a
'a
"a
"a"
None of which works.
I DO realize that the property expects a "range" in a sheet, in which the "items" are specified. However, I would prefer, not to have to have the values "lying openly around", in a spreadsheet, but to, rather, enter them DIRECTLY into the ListFillRange, or, if possible, any "other" ListBox Property.
Is this possible, in Excel?
Thanks!
C
Bookmarks