Help Needed with WorksheetFunction.VLookup

[vba_monkey]

Hello,

Can anyone please tell me what is wrong with this line of code. The aim is to determine if the field called Search_TB on a UserForm is blank or if whatever value is in that field is not in column 1 of a worksheet called ManSheet.

If Search_TB = "" Or WorksheetFunction.VLookup(Search_TB, ManSheet.Columns(1), 1, False) = 0 Then

I've tried lots of things but I'm constantly getting this error:

'Unable to get the VLookup property of the WorksheetFunction class'

 

[steve the fish]

See if this works:

If Search_TB.Text = "" Or IsError(Application.Match(Search_TB.Text, ManSheet.Columns(1),0)) Then

 

[Scott T]

To add to what Steve the fish posted

Vlookup returns an error when the value is not found, this is why you are getting the error.

 

[vba_monkey]

Thank you Mr Fish, that does the trick.

Thank you for the explanation, Scott.