My Excel Macros

Recording A Marco

Home

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)

 Open my full document.