VBA (Visual Basic for Applications) is the programming language used to create macros. A good knowledge of VBA can save time and make you a much more productive Excel user. VBA is a common programming language found in virtually all Microsoft Office applications. People will often learn VBA before progressing to other languages in due course.
When you have created a macro you might be wondering how you access them. The first way you can do this is by looking in the developer tab you will see a button called macros on the left hand side, if you click on that it will show you all the macros that are stored in a personal macro workbook on ones for that workbook only.
This will bring up this window which will display all macros which are in all of your open workbooks. This is also the place where it will show you the description so others can find out what they are meant to be used for. Once you have chosen what macro you want you can click run and it will run the macro.
If you want to display your macros in the ribbon instead this is how. First thing you need to do is open up the customise ribbon window, you do this by right clicking the ribbon and choosing customise ribbon.
Now on the right hand side of the Ribbon options you will see a list of what tabs are on the ribbon. You want to add a new tab, so at the bottom you will see a list of options you want to choose new tab first. This will create a new tab called new tab. It is a good idea to rename and to do this you need to highlight it and click rename, the best thing to call it is Macros. It automatically creates a new group with in that tab so you should rename that group to macros as well or you could categorize your macros for certain things that they do.
Now you can add your macros to the group. To do this you need to go to the drop down box above the left hand column and choose macros this will display all the macros you have created but remember if you stored them to a certain workbook you won’t be able to see them if you’re on another workbook. To add a macro to the group highlight the group you want and then click on the macros you want and click the add button in between the two columns.
When you have added your Macros you can rename them to whatever you want and you can assign an icon to them so you can easily see which ones are which. Now you can close that window and you should have anew tab called macros which displays your macros in a more visual way. You can now just click on which macro you want and it will run it.
You could attend a Excel VBA course which will teach this and more in a lot more detail.