Value of Combo Box
 

Hi. I am a VBA newbie, and am have created a drop down
list with 5 options in it. If they pick "Alabama", then
I want the value to be a 1, "North Carolina", 2, etc. I
will be using that value in a particular cell for a
formula, but don't know how to "retrieve" the value from
that drop down. Any advice? Thanks for any help!! I
know the code for the combo box is Forms.ComboBox.1.
:(

BR

Value of Combo Box
 

Combobox1.Listindex + 1
since listidex is zero based.

--
Regards,
Tom Ogilvy

"BigRed" wrote in message
...
Hi. I am a VBA newbie, and am have created a drop down
list with 5 options in it. If they pick "Alabama", then
I want the value to be a 1, "North Carolina", 2, etc. I
will be using that value in a particular cell for a
formula, but don't know how to "retrieve" the value from
that drop down. Any advice? Thanks for any help!! I
know the code for the combo box is Forms.ComboBox.1.
:(

BR