You will need to have some event to trigger the population of the textbox,
such as a combobox click event.

--

HTH

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

"NorTor" wrote in message
...
Dear Bob!

Gonna try it right way!
And this don't even need an onchange event, right? It is changing when
value in combobox is I guess.

Best regards :-)
NorTor



On Tue, 8 Jun 2004 21:53:21 +0100, "Bob Phillips"
wrote:

Use VLOOKUP ws function

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