You can use this to pop up that dialog
Application.Dialogs(xlDialogFormulaFind).Show
This is a discussion on Find Function within the Excel Questions forums, part of the Question Forums category; I've created a command button (control toolbox) that, when pushed, I'd like to return a response simliar to what you'd ...
I've created a command button (control toolbox) that, when pushed, I'd like to return a response simliar to what you'd get when you select a range of cells and push Ctrl+F. Except I'd like this button to do it both; select a range of cells that I define in addition to launching the 'Find' function.
Still learnin'
exceldvlpr
You can use this to pop up that dialog
Application.Dialogs(xlDialogFormulaFind).Show
Bookmarks