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)
Bookmarks