Hi everyone,
Quick question. I have a userform that has a combo box on it. I populate the combo box by using the:
Private Sub Userform_Initialize()
With Me.combobox1
.additem "first"
.additem "second"]
end with
end sub
The question is regarding the value of the combo box selection. Is there a way to have the combo box display, as in my code example, "first", but then when i ask for me.combobox1.value have it return something else, such as "1" or something to that effect.
My goal is to have a simple statement in the combobox which users will see, but their selection will lead to a value which i need and predefined.
Please let me know if this isnt clear enough. thanks for any help!
Quick question. I have a userform that has a combo box on it. I populate the combo box by using the:
Private Sub Userform_Initialize()
With Me.combobox1
.additem "first"
.additem "second"]
end with
end sub
The question is regarding the value of the combo box selection. Is there a way to have the combo box display, as in my code example, "first", but then when i ask for me.combobox1.value have it return something else, such as "1" or something to that effect.
My goal is to have a simple statement in the combobox which users will see, but their selection will lead to a value which i need and predefined.
Please let me know if this isnt clear enough. thanks for any help!