PDA

View Full Version : LISTDATA MISSING FROM COMBOBOX PROPERTIES



DeanP
11-26-2018, 06:56 AM
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!

Aflatoon
11-26-2018, 07:00 AM
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).