in VBA How to place ifError in this VLookup formula?

[epardo87]

Hi there, I have the formula below working perfectly fine in a VBA Form, but when the result is not found it pops up an error and send me to debug.

Cells(emptyRow, 5).Value = WorksheetFunction.VLookup(CLng(SerieTextBox.Value), Sheets("RecordPrint").Range("B:C"), 2, False)

I want to add an If isError condition so that if indeed Error then pops up a new window (CodigoUserForm.show)

Any suggestions?

Thanks!

 

[Jonmo1]

You're welcome.