Vba Script For Ctrl+f

[Mhz]

Hi, is there a macro code that will execute the ctrl+f function for the search feature? if so, could you please post it for me?

I want to use a button to click on my program that will display the search (Find) dialogue.

Thanks In Advance for any help on this...

[VBA Noob]

Hi,

Excel has a built in button to call Find.

Goto View > Toolbars > Customise > Command tab > Edit and select the Find

Drag to your toolbar

VBA Noob

[Leith Ross]

Hello Mhz,

Here is macro you can call from a button to launch the Find/Replace Dialog...

Sub FindReplace()

  SendKeys "^f", False
  
End Sub

Sincerely,
Leith Ross

[Mhz]

Thanks Very Much for the Responses!

Leith Ross, that is exactly what I needed... I want to be able to link the Macro to my created button on the sheet.. Thanks Very Much!

Thanks to you also VBA Noob, I forgot to mention to you that I was
creating my own button I wanted to link to the macro, but your info
is invaluable none the less, thanks for all your help..