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.