I am in need of a Macro to find an item that will search the entire workbook.
But the item that they are searching for will be different everytime. I would like a dialog box to open with they click a button. I just need the macro. I can later assign it to the button.
I want it to work like the Edit - Find option but when you click the button a dialog box opens asking you to enter an item that you want to find.
Can anyone help? This is what i have so far but it doesn't bring up a window to enter in an item.
But the item that they are searching for will be different everytime. I would like a dialog box to open with they click a button. I just need the macro. I can later assign it to the button.
I want it to work like the Edit - Find option but when you click the button a dialog box opens asking you to enter an item that you want to find.
Can anyone help? This is what i have so far but it doesn't bring up a window to enter in an item.
Code:
Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
End Sub