Message Box Prompt. Continue Or Cancel

Hey Everyone,

I'm using the find function in excel VB. I want to display a message box prompt if the text I'm searching isn't found. One that allows the user to continue running the code or cancel. But each time I try to implement a box I get errors. How could I go about doing this? Here is an example of my search function.


Thanks for your help everyone

Please Login or Register  to view this content.

What are you implementing that errors?

There's kind of two issues, I don't know how to implement code that says " hey! the search didn't find anything would you like to continue anyway?" and also when I try to create a message box I use the below code and get the error " Invalid Procedure call or Arguement"

Please Login or Register  to view this content.

Thanks for your interest

Please Login or Register  to view this content.

Excellent, thank you very much!