determine dropdown value

[geebee]

hi,

i would like to know how i can determine/display the value selected from a
dropdown box.

thanks in advance,
geebee

 

[Office_Novice]

If your DropDown is a comboBox from the control ToolBox you have a Couple of
options:

ComboBox1 .AddItem "Your First Item" ' To Add one at a time

Or ComboBox1.RowSource = "A1:A10" 'To Add from a sheet

There are a few other ways to populate a comboBox but these will get you
started.