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)
Macro Security settings
Learn how to apply Macro Security settings.
Get free tutorials, updates, tips and tricks and much more.
Subscribe to our
channel
Like us on
Follow us on
Complete and Continue