![]() |
My Excel Macros |
Recording A Marco |
Step 1 |
The first step is to record the macro to generate what is need. A macro will automate the process that you require. So for example if I was to record a macro whilst creating a chart in Excel, if I run the macro when I was finished it would create the chart for me. To record a macro the first thing is to click tools macro and then record. Click the images below to enlarge. |
Step 2
|
The next step is to start recording what you want the
macro to store. Is this example I will create a chart while using a macro
to record the process. Click the image below to enlarge.
|
Step 3 | When you have finished with the macro it can be stopped,
the next process is to assign a command button on a sheet to run the
macro. When this is done the macro can be tested from the command button.
Click the image below to enlarge.
|
Step 4 | The macro can now be edited using VBA, editing the VBA
will enable you to create a more accurate macro. VBA is very useful tool
it makes office applications very versatile. Access VBA by pressing alt +
f11 Click image below to enlarge.
|
My Macros (VBA Code) | |