In the combo click event

With Me
.txtBox.Text =
Application.Vlookup(.cboBox.Value,Worksheets("Shee t1").Range(A2:B20),2,False
)
End With

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"CMcK" wrote in message
...
Hello,
I'm new to VB programming (but not Excel), so please bear with me.

I'm creating a usrFrm with a cboBox (Project Name) & txtBox (Project No.).
I want the txtBox to return the corresponding value depending on what's
been
selected in the cboBox.
The cbo values are derived from a table on a worksheet:

Project name Project no.
a 1
b 2
etc,

Question: 1)would I need to use VLOOKUP in VB? If so, how?
2)how do I get the result of the VLOOKUP to be the value in
the txtBox?

Your help is very much appreciated.
Mac