B
BigRed
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
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