Find and Replace Macro

  • Thread starter Thread starter gtton
  • Start date Start date
G

gtton

Hi, how do I create a Find and Replace shortcut button on my Exce
Spreadsheet? Since I decided to hide the toolbars, they can't selec
Edit>Find...

Thanks,

Gar
 
Hi Gary,

Try assigning the following code to a button:

'=============>>
Private Sub CommandButton1_Click()
Application.Dialogs(xlDialogFormulaReplace).Show
End Sub
'<<=============
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display in Macro when editing the value of a Worksheet range 1
Can't get Find Box 4
Find and replace within VBA 2
XL2003 find and replace broken? 2
MACRO: Multiple Find / Replace 3
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Creating a hyperlink shortcut in the spreadsheet. 2
find and replace loop in VBA 0

Back
Top