displaying combobox text ???

[shawn876]

HI everyone:
I have a combobox which displays with the values
A, B, C.
What I need is when I select the text in the combobox I need to use that text to display in a table.
For example:
B is the value but in the combobox it shows up as Hi
I need use that text value.
Please help Thanks

 

[mrmovie]

can you use the OnClick, or Change event in the combobox

Then in the event handle do something like

Select Case ComboBox.Value
Case "A"
Case "B"
TextBox1.Text = "Hi"

End Select