Hello every body in my VBA code i have the folowing
xxxlist:
Name = InputBox("enter movie name")
If Name = Cancel Then
noanwser = MsgBox(" YOU DID NOT ENTER A MOVIE NAME DO YOU WISH TO EXIT THE PROGRAM", vbRetryCancel)
If noanwser = vbRetry Then GoTo xxxlist
If noanwser = vbCancel Then GoTo aend
moviedata = Application.WorksheetFunction. _
VLookup(Name, Range("movielistxxx"), 2, False)
now the problem im having is if the vlookup dosent find a corect anwser i get a run time error 1004 how could i make it now show this and even beter if i get this to execute an other function like a msgbox
can you please help this would be great
xxxlist:
Name = InputBox("enter movie name")
If Name = Cancel Then
noanwser = MsgBox(" YOU DID NOT ENTER A MOVIE NAME DO YOU WISH TO EXIT THE PROGRAM", vbRetryCancel)
If noanwser = vbRetry Then GoTo xxxlist
If noanwser = vbCancel Then GoTo aend
moviedata = Application.WorksheetFunction. _
VLookup(Name, Range("movielistxxx"), 2, False)
now the problem im having is if the vlookup dosent find a corect anwser i get a run time error 1004 how could i make it now show this and even beter if i get this to execute an other function like a msgbox
can you please help this would be great