Forum Discussion
Solved
RowSource Syntax in a Form ComboBox
I am using the following successfully to validate a form combo box [using the "RowSource" parameter] against a table on a work sheet with a single column :- LookupData!Table_Query_from_harglive9 Do...
- Generally speaking using the RowSource to fill a combobox on a userform is frowned upon. I always write the data to the combobox using the List property directly, e.g.:
ComboBox1.List = Worksheets("YourSheet").Range("TheNamedRange").Value
Note that it is also a good idea to name the range you are intending to use as the rowsource.
Generally speaking using the RowSource to fill a combobox on a userform is frowned upon. I always write the data to the combobox using the List property directly, e.g.:
ComboBox1.List = Worksheets("YourSheet").Range("TheNamedRange").Value
Note that it is also a good idea to name the range you are intending to use as the rowsource.
ComboBox1.List = Worksheets("YourSheet").Range("TheNamedRange").Value
Note that it is also a good idea to name the range you are intending to use as the rowsource.
thanks for the tip, but how can i make the listbox updated at the same time JKPieterse