VBA stands for Visual Basic for Applications an event driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as MS-Excel, MS-Word and MS-Access.
This tutorial will teach you basics of VBA and each of these sections contain related topics with simple and useful examples.
Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro.
MsgBox: The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.
Workbook and Worksheet Object: Learn more about the Workbook and Worksheet object in Excel VBA.
Range Object: The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA.
Variables: This chapter teaches you how to declare, initialize and display a variable in Excel VBA.
If Then Statement: Use the If Then statement in Excel VBA to execute code lines if a specific condition is met.
Loop: Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.
Macro Errors: This chapter teaches you how to deal with macro errors in Excel.
String Manipulation: In this chapter, you'll find the most important functions to manipulate strings in Excel VBA.
Date and Time: Learn how to work with dates and times in Excel VBA.
Events: Events are actions performed by users which trigger Excel VBA to execute code.
Array: An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number.
Function and Sub: In Excel VBA, a function can return a value while a sub cannot.
Application Object: The mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot of Excel related options.
ActiveX Controls: Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc.
Userform: This chapter teaches you how to create an Excel VBA Userform.
VERSION HISTORY
- Version 1.0.7 posted on 2016-04-18
Improve performance and design.,Added New Features learning apps like editor to check code etc
Program Details
- Category: Education > Teaching & Training Tools
- Publisher: Future Vision computers, Surat
- License: Free
- Price: N/A
- Version: 1.0.7
- Platform: android