VBA Coding
Definition
VBA coding stand for Visual basic and is a code that is run on the back end of excel. You can basically code anything you do in excel in VBA code as well. It works better and faster that the actual formulas in the front end,because you can customize quicker.
Where to find
You need to first insert the developer tab in your toolbars. Please read under toolbars and macros for a detail description of how to add this. If you have the developer toolbar, simply click on view code as below, and this will take you to the visual basic section.
Where to start
It is actually very easy to start using the VBA coding. Simply record a normal macro, then go into the code, and see how it looks. This will give you a good start of how the code is made up.
Example
Let's look at a simple example. Let's go into excel, create a button macro, and simple save the sheet and then close the macro.
The code for this look like follows:
Sub Button3_Click()
'
' Button3_Click Macro
''
ActiveWorkbook.Save
End Sub
All codes begin with a sub and end with a sub.
The way forward
Rather than trying to teach you all the functions avialably, which is millions, we will be posting different things that can be done with VBA coding on here, and also the code with a detailed explanation of how it works, so that you can easily implements this.
Topics
- Add multiple sheets and name them automatically
- Find the last used cell in a row and copy it somewhere else
- Insert hyperlinks automatically
<-----Back to index
Next topic----->
