-
LISTDATA MISSING FROM COMBOBOX PROPERTIES
I am trying to add lists to a 4 column combobox in auserform.
I wanted to use the combobox properties to do this, but theListdata field is missing, so I guess I have to use code to do it. However ………..
Every example of the code to use to do this isdifferent!! I am so confused, I have noidea how to do this at all.
My listdata is in worksheet Validation Range B2:E88 (NamedRange CustData)
Any help or pointing to an article website or anything wouldbe appreciated!
-
At design time you would set the Rowsource property to the address/name of the range. In VBA you can do the same or pass the value of the range to the List property (there is no Listdata property for either method).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules