Results 1 to 4 of 4

Thread: Topic 8: How Excel macro can Automate your complex tasks?

  1. #1
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10

    Topic 8: How Excel macro can Automate your complex tasks?

    Advertisement

    Macros can be played back or modified at any time.
    Advertisement

    To record a macro

    From the Tools menu, point to Macro and click on Record New Macro.
    From the Record Macro dialog box displayed, enter a name for the macro in the Macro name: text box.


    The default description is displayed in the Description: text box, and contains the date and user name. If required, change it.

    To begin recording, click OK.

    Perform the actions you want the macro to record. Actions can be any combinations of Excel commands.

    To stop recording, from the Tools menu, point to Macro and click on Stop Recording.


  2. #2
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    To assign a shortcut key to the macro

    From the Tools menu, point to Macro and click on Macros.
    From the Macro dialog box displayed, select the macro name (if recorded before) to which you want to assign a shortcut key.


    Click the Options ****on to display the Macro Options dialog box.

    Type a letter into the Ctrl+ text box. This combination key will be used to invoke the macro.

    Click OK to return to the Macro dialog box.

    Click on the Cancel ****on to close.

  3. #3
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    To run a macro using the Tools Macro command

    From the Tools menu, point to Macro and click on Macros.

    From the Macro dialog box displayed, click on the name of the macro you wish to run in the Macro name: list box.

    Click the Run ****on.Note: If you wish to edit or delete a macro, just click on the particular ****on.

    To run a macro using the assigned shortcut key

    Press Ctrl+?, with ? is the letter which you assigned.


    To create a ****on and assign an Excel macro to it

    If the Forms toolbar is not display, right click on any toolbar that is visible and from the pop-up menu that is displayed select Forms.

    To create a ****on, click the ****on icon on the Forms toolbar.


  4. #4
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    Then, click and drag the mouse to the intended ****on size.
    When release the mouse ****on, the Assign Macro dialog box will be displayed.


    Click on the Record ****on and the Record Macro dialog box will be displayed.

    Enter a name for the macro in the Macro name: text box.
    Click on the OK ****on.

    Record your macro in the normal way, and click on the ****on and select Edit Text from the pop-up menu.

    To run the macro, simply click on the ****on.


    To change a ****on name

    Double click on the ****on to highlight the ****on name.
    Type in a new name and click on any worksheet cell to deselect the ****on.


    To delete a ****on

    Click on ****on and press the Delete key.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •