ExcelBanter - How to pen the Find dialog box with a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to pen the Find dialog box with a macro (https://www.excelbanter.com/excel-programming/383781-how-pen-find-dialog-box-macro.html)

jonco

How to pen the Find dialog box with a macro

How do I call up the Find dialog box in a macro and have the macro goto the
data requested in the find dialog?
I've tried recording a macro and going to Find on the Edit menu and also
CTRL F to bring up the diaog box but neither work.
Thanks for your assistance.

Jon

Jim Thomlinson

How to pen the Find dialog box with a macro

This will bring up the find dialog...

Application.Dialogs(xlDialogFormulaFind).Show
--
HTH...

Jim Thomlinson

"jonco" wrote:

How do I call up the Find dialog box in a macro and have the macro goto the
data requested in the find dialog?
I've tried recording a macro and going to Find on the Edit menu and also
CTRL F to bring up the diaog box but neither work.
Thanks for your assistance.

Jon

[email protected]

How to pen the Find dialog box with a macro

Jon,

Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show
ActiveCell.Select

HTH
Paul

----------------------------------------

How do I call up the Find dialog box in a macro and have the macro goto the
data requested in the find dialog?
I've tried recording a macro and going to Find on the Edit menu and also
CTRL F to bring up the diaog box but neither work.
Thanks for your assistance.

Jon

All times are GMT +1. The time now is 05:12 PM.