Lack of Know how

[Fox]

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

but I don't know macros - please help?

 

[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