View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default 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