hi Guys,
I think this should be fairly obvious what I'm trying to do here, but I can't for the life of me understand the error.
Private Sub Lastfind_Click()
On Error GoTo ErrorHandler
QiForm.PartFind = MySearch
Module1.Find_Part
ErrorHandler:
MsgBox "Can only unclear last search just cleared"
Resume UserForm_Initialize
End Sub
Basically, if it can't find last find, not a problem just re initialize the form again. I could use an if statement for this, but I wanted to learn about error handling.
What does it mean by label if Userform_initialize is not one? Please help to get this working. I'm suspecting a syntax error, but I can't find anything on google that addresses this problem
Kind regards
Rob
Bookmarks