Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel VBA (Macros) with Projects
The Macro Recorder
Course Overview (3:33)
Defining Macros (3:09)
Application of Macros (6:15)
Recording a Macro (4:46)
Edit the recorded Macro and Shortcut key (2:46)
Saving a macro file (5:03)
Macro Security settings (3:38)
Running Macros (7:10)
Storage Location (5:34)
VBA fundamentals
What is Programming (5:41)
VBA Fundamentals (15:38)
Enable Developer Tab (1:10)
VBE (8:29)
Writing a small VBA code (8:31)
Building Procedures
How to create a sub procedure (4:39)
Adding Comments (3:28)
Types of procedures (2:04)
Calling Procedure (2:14)
Passing Arguments to the procedure (3:38)
Working With Excel VBA Functions
How to create functions (3:28)
How to use conditions in functions (2:17)
Using conditions If...Then....Else (17:19)
User Defined Functions (3:06)
Basics of VBA coding
Assigning a variable (2:08)
Different ways of assigning variables (15:57)
DataTypes (6:24)
Constants (2:33)
Operators (14:05)
Working with the dialog boxes
MsgBox (1:09)
Adding arguments to the msg box (1:48)
Input Box usage (6:17)
Working with the objects
Object Reference Model (7:53)
Range (5:24)
Cell objects (3:27)
Range Properties and Methods (3:22)
Range Count Property (1:36)
Mergecell & range (3:14)
Range Select (0:47)
Selection of Rows and Columns (4:19)
Difference between Dim and Set (1:40)
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:07)
Do while-loop (5:35)
Do-loop while (1:56)
Assignment (10:15)
For Each…Next (4:35)
Events - Triggering code with Events
Creating Events(Open Event) (5:18)
Close Events (1:18)
Workbook Activate Sheet Events (2:04)
Workbook Activate Events (1:36)
Worksheet ActivateDec Events (1:46)
Application Events (7:36)
Creating Excel Add-ins
how to create Excel Add ins (4:53)
Debugging And Error Handling
Error Handling (12:58)
Debugging (7:20)
Speeding Up The VBA Tips (7:59)
Working with the Arrays in VBA
Array Function (4:28)
Dynamic and Fixed Arrays (12:02)
Size of Array (2:37)
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:26)
How to create a userform canvas (0:47)
Adding controls to the userform (6:44)
How to set the properties to userform controls (6:55)
Adding codes to the form controls (6:29)
Allowing The User To Highlight A Range using VBA (1:22)
Allowing The User To Highlight a Range using Userform (2:10)
How to create scrollbars and spinbutons in the userfom (5:28)
Adding images to the Userform (8:32)
How to add an Image in the Userform using a list box (1:45)
Adding Option Buttons In a Frame (6:03)
Multiple Tabs On A UserForm (5:37)
Controlling Tab Order and Aligning Controls (7:01)
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:14)
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:22)
Outlook Mails (1:55)
Sending Outlook Mails with Attachment (2:26)
Case Study
Password Protection (3:49)
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:46)
Close Events
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock