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

Dim FieldTotalEst As Range
    Set FieldTotalEst = Worksheets("Daily Report").Cells.Find(What:="Field Total Est.", LookIn:=xlFormulas, LookAt:=xlWhole, _
                       SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, _
                       SearchFormat:=False)