How to get started VBA code writing?

In previous lesson when we record macro the coding will be place in Visual Basic Editor (VBE) modules. Same goes to writing, if you want to write your own code go to VBE and insert modules and you can start writing begin with Sub and end with End Sub as below: Sub nameofyourmacro () Write your own code here! End Sub But before that we must learn Visual Basic programming language. In Visual Basic programming we will cover below topics:

1. Introduction to VBA
2. Objects and Collections
3. Workbook and Worksheet Object
4. Range Object and Cells Property
5. Methods and Property
6. Assigning Object Variables and Using Named Argument
7. Creating and Managing Array
8. Declare an Array With Dim Statement
9. Resize an Array With Redim Statement
10. Manage Dynamic Array
11. Create Multi-Dimensional Array
12. Find The Size of an Array
13. Working with Variables in Excel VBA
14. Message Box
15. Using If...Then...Else
16. For....Next Loop
17. Do.......Loop
18. Select Case........End Select
19. Font and Background Color

The above topic will be covered inside next tutorial. Actually you don't have to be worried because learning Visual Basic programming language it's easy unless you don't understand English. he eh. Good Luck.. Click here if you have any new project! Let us create for u for free. Thanks