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