How to have a macro simply issue the "find" command or "control f:

[Guest]

I would like to have a button in my worksheet to issue the find or control F
command. This would put all the controls I need at the users fingertips. I am
trying to record the macro but it will not let me stop until I perform a
search which I want the user to define what text is being sought.

 

[Guest]

in the button click event try this

Application.SendKeys "^f"

 

[Guest]

Another method:

Application.Dialogs(xlDialogFormulaFind).Show

HTH

 

[Robert]

Would you know how to have the find command within a cell?