Command Buttons and Macros

[macx]

I've looked thru Excel Help, but can't find how to
install a button on a worksheet (not in a toolbar)
and assign a Macro to it.

Or is there another simple way to perform an
action, such as erasing specific cells within
a group of cells so the form can be re-used
without having to select all the cells separately
and doing the erase command?

Thanks!

 

[macx]

OK - figured out how to record and assign a macro to a text box.
In this case the text box says ERASE and the macro assigned to it
erases a specific set of cells.

Now - I have a group of cells containing this text box and macro
that I would like to replicate a lot of times, sort of like a form where
I want different info in each replication.

How do I copy & paste and have the macro apply to the new, copied
group of cells rather than remaining applied to the original group?

Thanks!!