How can I get the "Find and Replace" dialog box to show when workbook is opened.

[EdwinK]

I'd like to be able to have the "Find and Replace" dialog box to show when workbook is opened. Is there a way to do this in visual basic?

 

[VoG]

Try this in the ThisWorkbook module

Private Sub Workbook_Open()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

 

[EdwinK]

That's exactly what I needed. Thanks again!