VBA (Visual Basic for Applications) is a programming language which is run at the back end of Microsoft Excel and other programmes. With the help of VBA we can create Macros to automate our work.
1.
Create a Macro: in this
chapter we will learn that how to create simple and easy macros with the help
of VBA.
2.
MsgBox: The MsgBox
is a dialog box in Excel VBA we can inform the users about oru program.
3.
Workbook and Worksheet Object: here we will
learn more about Workbook and Worksheet object in Excel VBA.
4.
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.
5.
Variables: Here we will
learn that how to declare, initialize and display a variable in Excel VBA.
6.
If Then Statement: Use the If
Then statement in Excel VBA to execute code lines if a specific condition is
met.
7.
Loop: Looping is a
programming techniques. A loop in Excel VBA enables us to loop through a range
of cells with just a few codes lines.
8.
Macro Errors: Here we will
learn how to deal with macro errors in Excel.
9.
String Manipulation: Here we will
learn how to manipulate strings in Excel VBA.
10.
Date and Time: How to work
with dates and times in Excel VBA.
11.
Events: The actions
is performed by users is called Event which triggered to execute the code
written in Excel VBA
12.
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.
13.
Function and Sub: A function
can return a value while a sub cannot.
14.
Application Object: Microsoft
Excel itself is an Application object which gives access to a lot of Excel
related options.
15. ActiveX Controls: Learn how to create ActiveX controls, such as command buttons, text boxes, list boxes etc.
16. Userform: here we will learn how to create a Userform in Excel VBA.
To become an expert in Microsoft Excel VBA you can find related examples and features on the right side of each chapter. For an overview you can read the following
1.
Create a Macro: Swap Values | Run Code from a Module | Macro Recorder | Use Relative References | FormulaR1C1 | Add a Macro to the Toolbar | Enable Macros | Protect Macro
2.
MsgBox: MsgBox Function | InputBox Function
3.
Workbook and Worksheet Object: Path and FullName | Close and Open | Loop through Books and Sheets | Sales Calculator | Files in a Directory | Import Sheets | Programming Charts
4.
Range Object: CurrentRegion | Dynamic Range | Resize | Entire Rows and Columns | Offset | From Active Cell to Last Entry | Union and Intersect | Test a Selection | Possible Football Matches | Font | Background Colors | Areas Collection | Compare Ranges
5.
Variables: Option Explicit | Variable Scope | Life of Variables | Type Mismatch
6.
If Then Statement: Logical Operators | Select Case | Tax Rates | Mod Operator | Prime Number Checker | Find Second Highest Value | Sum by Color | Delete Blank Cells
7.
Loop: Loop through Defined Range | Loop through Entire Column | Do Until Loop | Step Keyword | Create a Pattern | Sort Numbers | Randomly Sort Data | Remove Duplicates | Complex Calculations | Knapsack Problem
8.
Macro Errors: Debugging | Error Handling | Err Object | Interrupt a Macro | Subscript Out of Range | Macro Comments
9.
String Manipulation: Separate Strings | Reverse Strings | Convert to Proper Case | Instr | Count Words
10.
Date and Time: Compare Dates and Times | DateDiff Function | Weekdays | Delay a Macro | Year Occurrences | Tasks on Schedule | Sort Birthdays
11.
Events: BeforeDoubleClick Event | Highlight Active Cell | Create a Footer Before Printing | Bills and Coins | Rolling Average Table
12.
Array: Dynamic Array | Array Function | Month Names | Size of an Array
13.
Function and Sub: User Defined Function | Custom Average Function | Volatile Functions | ByRef and ByVal
14.
Application Object: StatusBar | Read Data from Text File | Write Data to Text File | Vlookup
15.
ActiveX Controls: Text Box | List Box | Combo Box | Check Box | Option Buttons | Spin Button | Loan Calculator
16.
Userform: Userform and Ranges | Currency Converter | Progress Indicator | Multiple List Box Selections | Multicolumn Combo Box | Dependent Combo Boxes | Loop through Controls | Controls Collection | Userform with Multiple Pages | Interactive Userform
No comments:
Post a Comment