View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NorTor[_3_] NorTor[_3_] is offline
external usenet poster
 
Posts: 14
Default Userform: Textbox changing with selection in combobox (list)

Hello,

I am stuck on how to solve this problem.

I have an userform with a combobox, which has a source in a sheet (a
table of roughly 200 rows)

The source table consists of two columns (and about 200 rows, already
mentioned).

Now, I am trying to get the textbox to show the text from column 2 of
my source table (the combobox gives the user the choice to select from
column 1 of the source table). If the user changes his selection in
the combobox, the textbox should then change to the corresponding
value from column two.

Please, can anyone help me a bit further on the way...? I figure it
might be some 'on-change' event of the combobox...


Cheers
NorTor