• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Record A Macro

Yes


Macros are saved as part of a file and then available every time that file is loaded


Macros can be made to occur when special events occur like opening or closing the file, , printing the file, changing sheets or changing cell contents etc


Macros can be stored in special files so that they are available to you in any file you have open. refer: personnel.xlsx


Macros, generally refers to a collection of key strokes or actions which a program records and then is available to you to use to repeat the same combinatiojn of actions.


Programs or subroutines are a smarter version of these as they use VBA (in Excel) which has a whole suite of extras which make the subroutines a lot smarter. These extra controls includes loops and branching, allow you to conditionally control what your subroutine is doing.


To record a Macro click the Little Worksheet Icon with a Red Oreb on it (Lower Left corner of screen).

Make a few changes to your worksheet, add some numbers or change some or delete some cells etc

Stop Recording (the same Icon)

Look at your code Alt F11 and select your Worksheets, Code Module
 
Back
Top