Value of Combo Box

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Combo box 0
Userform to query? 3
list or combo box 0
combo box 2
Combo boxes in excel 6
Combo or list box 0

Top