VBA

VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now predominantly used with Microsoft Office applications such as MS-Excel, MS-Word and MS-Access.

This tutorial teaches the basics of VBA. Each of the sections contain related topics with simple and useful examples.
This reference has been prepared for the beginners to help them understand the basics of VBA. This tutorial will provide enough understanding on VBA from where you can take yourself to a higher level of expertise

 

1. VBA ─ OVERVIEW
2. VBA ─ EXCEL MACROS
3. VBA ─ EXCEL TERMS
4. VBA ─ MACRO COMMENTS
5. VBA ─ MESSAGE BOX
6. VBA ─ INPUTBOX
7. VBA ─ VARIABLES
8. VBA ─ CONSTANTS
9. VBA ─ OPERATORS
10. VBA ─ DECISIONS
11. VBA ─ LOOPS
12. VBA ─ STRINGS
13. VBA ─ DATE-TIME FUNCTION
14. VBA ─ ARRAYS
15. VBA – USER-DEFINED FUNCTIONS
16. VBA ─ SUB PROCEDURE
17. VBA ─ EVENTS
18. VBA ─ ERROR HANDLING
19. VBA ─ EXCEL OBJECTS
20. VBA ─ TEXT FILES
21. VBA ─ PROGRAMMING CHARTS
22. VBA ─ USER FORMS