How to get the "Find" control to pop up using the onclick event

[jjk238]

Hello,

I am trying to get the "Find and Replace" control (ctrl + f) to pop up when the user clicks on a command button. The button is embedded into an Excel workbook. I also would like the control to be opened with the options shown and the "Within" field to be selecting workbook.

I have tried to record a macro to do this, but it doesn't record anything. I hope that this is possible and I apologize if it's something easy that I am overlooking. Thanks!!

JJ

 

[Andrzejek]

You are in VB 5 and 6 and we don't have any 'onclick" events.

You may want to ask in here, VBA group.

Have fun.

---- Andy

 

[MajP]

Application.Dialogs(xlDialogFormulaFind).Show