Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel VBA (Macros) with Projects (Offline)
The Macro Recorder
Course Overview (3:33)
Defining Macros (3:09)
Application of Macros (6:15)
Recording a Macro (4:48)
Edit the recorded Macro and Shortcut key (2:49)
Saving a macro file (5:16)
Macro Security settings (3:38)
Running Macros (7:10)
Storage Location (5:34)
VBA fundamentals
What is Programming (5:47)
VBA Fundamentals (15:38)
Enable Developer Tab (1:10)
VBE (8:33)
Writing a small VBA code (8:36)
Building Procedures
How to create a sub procedure (4:40)
Adding Comments (3:30)
Types of procedures (2:04)
Calling Procedure (2:21)
Passing Arguments to the procedure (3:38)
Working With Excel VBA Functions
How to create functions (3:29)
How to use conditions in functions (2:27)
Using conditions If...Then....Else (17:32)
User Defined Functions (3:06)
Basics of VBA coding
Assigning a variable (2:08)
Different ways of assigning variables (15:57)
DataTypes (6:41)
Constants (2:33)
Operators (14:08)
Working with the dialog boxes
MsgBox (1:09)
Adding arguments to the msg box (1:48)
Input Box usage (4:51)
Working with the objects
Object Reference Model (8:06)
Range (5:24)
Cell objects (3:33)
Range Properties and Methods (3:22)
Range Count Property (1:36)
Mergecell & range (1:24)
Range Select (0:47)
Selection of Rows and Columns (4:19)
Difference between Dim and Set (1:39)
Understanding Worksheet Object (1:58)
Worksheet properties and methods (3:10)
Understanding workbook object (2:06)
How to Delete a workbook (0:53)
Application Objects (2:45)
Object Browser (5:21)
Manipulating Excel Objects
Offset (10:18)
Application of Offset (4:23)
Offset property in VBA (2:19)
Loops
Loops (2:11)
For-next loop (12:27)
Do while-loop (5:38)
Do-loop while (1:56)
Assignment (10:29)
For Each…Next (4:34)
Events - Triggering code with Events
Creating Events(Open Event) (5:18)
Close Events (1:20)
Workbook Activate Sheet Events (2:04)
Workbook Activate Events (1:36)
Worksheet ActivateDec Events (1:46)
Application Events (7:52)
Creating Excel Add-ins
How to create Excel Add-ins (4:56)
Debugging And Error Handling
Error Handling (13:10)
Debugging (7:20)
Speeding Up The VBA Tips (8:46)
Working with the Arrays in VBA
Array Function (5:07)
Dynamic and Fixed Arrays (12:26)
Size of Array (2:38)
Working with the Userforms
Selecting a Range with The Input Box (4:51)
An Introduction To UserForms (1:18)
Step by step process of creating a userform (3:28)
How to create a userform canvas (0:47)
Adding controls to the userform (6:46)
How to set the properties to userform controls (6:57)
Adding codes to the form controls (6:38)
Allowing The User To Highlight A Range using VBA (1:27)
Allowing The User To Highlight a Range using Userform (2:11)
How to create scrollbars and spinbutons in the userfom (5:28)
Adding images to the Userform (8:46)
How to add an Image in the Userform using a list box (1:45)
Adding Option Buttons In a Frame (6:33)
Multiple Tabs On A UserForm (5:40)
Controlling Tab Order and Aligning Controls (8:57)
Working on a Live project
Data mining with Advanced Filters (3:38)
Split Data to Multiple Worksheets Method 1 (1:34)
Split Data to Multiple Worksheets Method 2 (3:54)
How to split the Filtered Data onto Multiple Workbooks (3:25)
How to combine Multiple Worksheets to one single Worksheet in Excel? (3:17)
Merging Data from Multiple Workbooks into a Summary Workbook (5:15)
Using VBA to create Pivot tables (4:42)
Assignment (1:31)
Using VBA to create Charts (9:50)
Concept of Binding (5:38)
Automating Word Using Excel VBA (4:22)
Export charts to Powerpoint using Excel VBA (1:21)
Export the data to Powerpoint (1:21)
Outlook Mails (1:55)
Sending Outlook Mails with Attachment (2:26)
Case Study
Password Protection (3:54)
Creating Hyperlinks to all the Worksheets (2:23)
Creating Hyperlinks to all the Workbooks (2:10)
Protect-Unprotect all the Worksheets using Password (2:14)
Protect using Password (1:34)
Data Transpose Using Offset (2:24)
Conclusion (2:47)
Topic 4 - Executing the demo apps (4:15)
Running Macros
Understandwhat are the different ways in which you can run a macro.
TECHNIQUES:
USING A SHORTCUT KEY TO RUN A MACRO
USING COMMAND BUTTON
USING SHAPES TO RUN A MACRO
USING F5 SHORTCUT KEY TO RUN A MACRO
USING QUICK ACCESS TOOL BAR
Complete and Continue