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

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.

in the button click event try this

Application.SendKeys "^f"


"Charles Adams" wrote:

> 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.
>
>

Another method:

Application.Dialogs(xlDialogFormulaFind).Show

HTH

"Charles Adams" wrote:

> 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.
>
>