Using VLOOKUP In A UserForm

Hi all,

I have a userform and I'm trying to use VLOOKUP in one of the textboxes to pick up data from a sheet ('Potential'). However, when I run the Userform nothing is happening. I am using the following code:

Private Sub newSheet_Change()

newSheet.Value = Application.VLookup(projName.Value, Sheets("Potential").Range("A5:E75"), 2, 0)

End Sub

Any suggestions what I'm doing wrong?

TIA,

SamuelT

Check this out
http://www.freewebs.com/davesexcel/U...rTextBoxes.xls

I would use the VBA .Find method.

What is newSheet? If it is the textbox to receive the result then you need to trigger the code