Hi Ppl,
I have written the following code to provide a vlookup function for my textbox this works great.
Problem is if the vlookup can't find the value is assigns the value of Desc to be Error 2042 which when used comes out as #N/A.
Question is how can I pick up that error and direct my actions accordingly?
With Sheets("Sheet1")
Desc = Application.VLookup(CDbl(ProdCode), Range("A:D"), 3, False)
End With
Any Help is appreciated
Rgds Brett
I have written the following code to provide a vlookup function for my textbox this works great.
Problem is if the vlookup can't find the value is assigns the value of Desc to be Error 2042 which when used comes out as #N/A.
Question is how can I pick up that error and direct my actions accordingly?
With Sheets("Sheet1")
Desc = Application.VLookup(CDbl(ProdCode), Range("A:D"), 3, False)
End With
Any Help is appreciated
Rgds Brett