simora
12-06-2009, 03:27 PM
I need to show a combobox on a userform with 2 columns of data that lists the states in the US. What I want to do is to show the full state name in the selection area of the combo box, along with the abbreviation, but send only the abbreviated representation to the spreadsheet.
So that for example New York is shown in the combo box & NY, but NY is sent to the worksheet when selected.
Whats the best way to set this up and impliment it?
Thanks
So that for example New York is shown in the combo box & NY, but NY is sent to the worksheet when selected.
Whats the best way to set this up and impliment it?
Thanks