I am using a piece of vba code to 'Find' a cell containing a string.
If the string is Found then I am updating a UserForm
If the string is Not Found I am displaying a Message box

Instead of the Message Box (above) I would like to display the built in
dialog that Excel displays, when the data is not found, when doing the Find
manually


"ben" (remove this if mailing direct) wrote in message
...
What do you mean dialog box? What are you trying to accomplish with the
find
and then the subsequent failure or success?
Ben
--
When you lose your mind, you free your life.


"Jim" wrote:

Thanks Otto, that has set my mind at rest
Is there an Excel dialog box that I can use instead of a message box ?

Regards & TIA


"Otto Moehrbach" wrote in message
...
Yes. HTH Otto
"Jim" wrote in message
. uk...
I am using a piece of vba code to 'Find' a cell containing a string.
If the string is Not Found the code returns an error 91 - Object
Variable
or With Block Variable not set which I am displaying in a msgbox
Is this the correct Error for a failure to find a string ?