Command Buttons and Macros

By macx
Oct 6, 2006
Topic Status:
Not open for further replies.
  1. 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!
  2. macx

    macx TechSpot Maniac Topic Starter Posts: 738

    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!!
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.