How to get entries into a combox on a form?
 

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

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

How to get entries into a combox on a form?
 

Both work beautifully

thanks again

"Vergel Adriano" wrote:

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