Command Buttons and Macros

By macx
Oct 6, 2006
  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?

  2. macx

    macx TS Evangelist Topic Starter Posts: 718

    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?

Topic Status:
Not open for further replies.

Similar Topics

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...