Lack of Know how

F

Fox

I want to make a button that activates the Find (ctrl-F) function....

but I don't know macros - please help?
 
D

Dave Peterson

You could use the keyboard shortcut (Ctrl-F).

You could add an icon to your favorite toolbar.
Tools|Customize|Commands Tab|Edit Category (near the bottom--look for
binoculars).

Or you could have a macro that looks like:

Option Explicit
Sub ShowFindDialog()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

To make it available quickly, you could assign it to a shortcut key. Maybe
ctrl-F, hey, wait! (or put a button from the Forms toolbar on your worksheet
and assign this macro to the button.)

Since you're new to macros, you can read some notes at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 

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

Top