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.

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

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.

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

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.

How to have a macro simply issue the "find" command or "contro
 

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

"quartz" wrote:

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.