View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default 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.