Hello Every one..

I have this combo box that control source as ID keys. is column count in 2 with the width of 0";1" so the txt value appear in drop down list in combo box but the default value in number and it is hidden.
my question is how can i point the text value in VBA Code. so that it will appear in other textbox as text not as numbers?


hope you understand want to ask..

Thanks in advance for the quick reply..

You can refer to the columns of a combo (or list) box using the syntax:
Where x is the numeric index of the column you want to address. The first (leftmost) column being Column(0).

That it!
it work.. thanks Sinndho

You're welcome!