Intergate Find Into Macro

[Yellowdude]

This may sound pointless but is there anyway to open the find menu in my own macro and keep it open? When I try to record I have to close the find window before clicking stop.

 

[Dave Hawley]

Try:

Sub OpenFileMenu()
Application.CommandBars("Worksheet Menu bar").Controls("&File").Execute
End Sub

 

[Yellowdude]

Thanks whats the step after that to select the find option

 

[Dave Hawley]

Oh! If you only wnat that use:

Application.Dialogs(xlDialogFormulaFind).Show

 

[Yellowdude]

Yes brill
Thx.