Use VLOOKUP ws function

Textbox1.Text = Application.VLookupCombobox1.Value, Range("A1:B20"), 2,
False)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"NorTor" wrote in message
...
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