Edit/Find macro

[bpgolferguy]

Is there a macro or VBA code I can attach to a button to prompt the Edit->Find box? I just want to have it be user friendly and have a button that will "call" it right there on the spreadsheet. Thanks!

 

[jim may]

You do know the combination of the ControlKey + F will bring up the Find Dialog box.

 

[kolle_hond]

Sub findButMacro()
Application.SendKeys ("^f")
End Sub

hope this helps

 

[jim may]

Application.Dialogs(xlDialogFormulaFind).Show