VBA Training
Learn how to automate your work in Microsoft Excel with Visual Basic for Applications.
Visual Basic for Applications (VBA) is a scripting language developed by Microsoft which allows the development of user-defined functions and the automation of certain processes and calculations.
VBA is built into most Microsoft Office applications to extend their functionality. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.
Objectives:
1. Make repetitive reports, dashboards or slides and looking for ways to automate
2. Want to learn VBA to understand and use Excel better
3. Want to use Excel for more powerful & demanding tasks
4. Create user forms to accept or display data, validate the data entry in user forms.
5. Debug and Handle errors in code.
Prerequisites:
1. Well versed with Advanced Excel Features like charting, Filtering and Pivot Table.
2. Basic Knowledge in the Programming will be added advantage.
VBA Modules
How to access worksheet cells with a macro in Excel
How to access Excel worksheet cells using the cell property in a macro
Autofit Data Automatically in Columns in MS Excel
How to Extract or Pull Specific Words from a Database or Collection
Merge data of Excel cells without losing data using VBA
Calculations in excel using macros
How to Confirm Data Entry Values in an Excel Worksheet Using VBA
How to Transfer Data from One Excel Workbook to Another Automatically
How to Convert MS Excel Formula to VBA Code
How to increase or decrease the value of a worksheet cell automatically
Find Duration in Hours between two Dates using VBA
Formatting Text and Numbers using macro in Excel
Interactive Calculations Macro – ActiveCell, Offset and Inputbox
Update Appointments Data Automatically in MS Excel
If-Else Function Macro
Project end warning with and without VBA
Interesting Excel VBA Example
Nested-If Function Macro
Automation Using a ‘Do While’ Loop in Macro Microsoft Excel
Convert Numbers to dates Using Excel VBA
For Loop – Excel VBA Training
Generating permanent random numbers using an Excel macro
Lottery game in Microsoft Excel
Save Excel Files Automatically Using Cell Data
Copy Paste Data from one Excel Worksheet to Another
How to copy data from one Excel worksheet to another and print
Class Module, Objects and Collections in Excel VBA
How to sort Excel data automatically
Automatic Report Generation in MS Excel
Automatic Non-Volatile Date & Time entry using Excel VBA
How to auto-run a VBA project
Protect Excel Worksheet Using VBA
How to Display Tip of The Day in Excel Using VBA
How to create timer-counter using Excel VBA
How to Print Specific Worksheet from Multiple Worksheets in Workbook Using VBA
Automatically Select Entire Worksheet Row on Click inside any cell Using Excel VBA
Error Handling in MS Excel Visual Basic for Applications VBA
Debug Excel VBA Code Line by Line for Errors
Assign Keyboard Shortcut to Macros Using Excel VBA
Transfer Data from Multiple Workbooks into Master Workbook Automatically
Move Excel Workbooks from one Folder to another Using VBA
Charts using VBA
Create Charts Using Excel VBA
Embed Chart in Worksheet Using Excel VBA
Pivot Tables using VBA
Create Pivot Tables Using VBA – Pivot Cache
How to manipulate Pivot Fields in Pivot Table using VBA
How to Update PivotTable When Source Data in Excel Worksheet Changes
Manipulate Pivot Items with VBA
Add Pivot Chart to Excel Worksheet Using VBA
VBA UserForms
What is a user-form in Excel?
User Form to automate calculations and validate data entry
Find the next blank or empty row for automatic data entry using Excel User Form
Adding and using a combo-box on a Userform
Using a List Box on an Excel UserForm
How to Fill List box on Excel User-Form with Unique Values from Worksheet
Display all worksheets of a workbook in listbox and print specific worksheet
Interesting Use of Combo-Box Form Control
Add and code the clear and cancel command buttons on userform
Open userform automatically
How to open & Close Userform Automatically Using excel VBA
How to Open the UserForm using a Command Button on a Worksheet
User Form to perform specific calculations
Show/Hide Controls on a User-Form using a Checkbox
Display or Hide Controls on UserForm Using Option Buttons
Populate List box and Text boxes with Excel data using VBA and Vlookup
How to use multiple list boxes on a user-form in MS Excel
How to focus on a specific control (TextBox1) on a user-form in MS-Excel
Inventory Management – User-Forms
Display Message in One Text Box Based on Entry in Another Text Box
Limit user input in a text box or an Excel Worksheet Cell
How to Allow ONLY Numerical Values in Excel user-form Text-Box Using VBA
Design User-Fo
|