How to get entries into a combox on a form?
Hi,
You can add items by:
ComboBox1.AddItem "Item 1"
ComboBox1.AddItem "Item 2"
' and so on...
or, you can set the rowsource property to a range:
ComboBox1.RowSource = "Sheet1!A1:A10"
--
Hope that helps.
Vergel Adriano
"Grd" wrote:
Hi everybody
I have a dropdown that I want to list various depts - sales, finance etc...
This should be easy but I dont know how to do it.
Thanks for your help.
Suzanne
|