"Do…While" | Yoda Learning Academy

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel VBA Tutorials - Learn Excel Programming Language with a practical approach

Instructions Manual

Course Manual

Downloadable Files:

Downloadable Working files and Case studies (0:16)

INTRODUCTION 1

Why learn Macros? (4:19)
Activate "Developer" tab (2:03)
Saving a Macro-enabled WorkBook (XLSM) (2:54)
Macro Security Settings (2:14)
Developer tab - Essential Buttons (0:54)
Head & Tail of a Macros (Sub Procedure & User Defined Function) (4:03)
"Click Here" button to run a Macro (1:46)
Excel VBA Macro Quiz #1

INTRODUCTION 2

Macros - Record & Run (5:10)
Macros - Viewing the code (2:42)
Macro-free vs. Macro-enabled Workbook (0:55)
Visual Basic Editor (VBE) (3:19)
Personal Macro WB (5:20)
Ways to Run a Macro (2:47)
Excel VBA Macro Quiz #2
Excel VBA Tutorials Feedback

GOOGLE

Using Google to locate useful VBA codes - 1 (7:45)
Using VBE and Macro Recorder to customize Macro code (4:48)
Using Google to locate useful VBA codes - 2 (6:31)
Excel VBA Tutorials Feedback

OBJECTS, PROPERTIES, METHODS

Objects, Properties, Values, Methods and Parameters 1 (2:20)
Objects, Properties, Values, Methods and Parameters 2 (1:58)
Excel VBA Macro Quiz #3 - OBJECTS, PROPERTIES, METHODS
Excel VBA Tutorials Feedback

WORKSPACE

Code Color & Activating Edit Toolbar w. Comments (3:01)
Edit Toolbar - Indent, Bookmark (1:49)
Code writing shortcuts incl. Intellisense (1:59)
Testing the Code (2:59)
Immediate Window 01 (3:07)
Excel VBA Macro Quiz #4 - WORKSPACE
Excel VBA Tutorials Feedback

RANGE & CELLS OBJECT

Range Selection - Method 1 (4:58)
Range Selection - Method 2 & 3 (3:22)
Advantage of Range Selection - Method 2 & 3 (5:51)
Range Selection (Rows & Columns) - Method 4 (0:54)
Assigning values to selected range of cells (2:01)
Exercise 1 - Assigning values to selected range of cells (1:35)
Exercise 2- Assigning values to selected range of cells (0:46)
Multiple Range Selection - Method 5 (2:02)
Multiple Range Selection - Method 6 (2:20)
Range Selection Ways - Others (2:05)
Excel VBA Macro Quiz #5_1 - RANGE & CELLS OBJECT
Excel VBA Macro Quiz #5_2 - RANGE & CELLS OBJECT
Excel VBA Macro Quiz #5_3 - RANGE & CELLS OBJECT
Excel VBA Tutorials Feedback

ABSOLUTE vs RELATIVE REFERENCE

Offset - Basics (1:54)
Using Relative Reference in Macros (3:12)
Excel VBA Macro Quiz #6 - ABSOLUTE vs RELATIVE REFERENCE
Excel VBA Tutorials Feedback

RANGE NAVIGATION

Navigating between a range of cells - Part 1 (2:15)
Navigating between a range of cells - Part 2 (1:20)
Navigating between a range of cells - Part 3 (1:50)
Exercise - Finding Last Row No. (4:19)
Exercise - Finding Last Column No. (3:43)
Exercise - Finding Next Row No. (1:25)
Excel VBA Macro Quiz #7 - RANGE NAVIGATION
Excel VBA Tutorials Feedback

VARIABLE DECLARATION

Variable Decl 01 (4:29)
Variable Decl 02 (2:04)
Pvt vs Public 01 (2:17)
Pvt vs Public 02 (5:34)
Option Explicit (4:31)
Difference - DIM vs. SET (2:04)
Excel VBA Macro Quiz #8 - VARIABLE DECLARATION
Excel VBA Tutorials Feedback

LOOPS

"For...Next" (3:28)
"If...Else...End If" nested within "For...Next" (5:25)
"Do…While" (7:32)
"Do…Until" (3:01)
"For Each...Next" (4:10)
"If...End If" nested within "For Each...Next" (4:48)
Exercise - "Do While" and Loop Counter (11:57)
"With…End With" - Example 1 (1:26)
"With…End With" - Example 2 (2:38)
"Select…Case" - Demonstration (2:22)
"Select…Case" - Explanation (5:20)
Excel VBA Loop - Macro Quiz #9
Excel VBA Tutorials Feedback

OPTIMIZING CODE EFFICIENCY

Speed up the code running - 1 (3:17)
Speed up the code running - 2 (2:34)
Speed up the code running - 3 (2:23)
Excel VBA Macro Quiz #10 OPTIMIZING CODE EFFICIENCY
Excel VBA Tutorials Feedback

EVENTS

Introduction (1:50)
Events - Workbook Open and Worksheet Activate (4:42)
Exercise 1 - Tracking Workbook Opens (8:29)
Exercise 2 - Tracking Workbook Save (3:47)
Event - Worksheet Before Double Click (6:53)
Event - Worksheet Change (4:39)
Event - Worksheet Calculate (2:42)
Pivot Table - Refresh - Work Sheet Activate (3:56)
Excel VBA Macro Quiz #11 Events
Excel VBA Tutorials Feedback

INPUT BOX

Introduction (2:34)
Input Box - 1 (5:13)
Input Box - 2 (5:38)
Input Box - 3 (2:55)
Input Box - 4 (6:53)
Excel VBA Macro Quiz #12 INPUT BOX
Excel VBA Tutorials Feedback

MSG BOX

Introduction to Msg box in excel vba (1:36)
MsgBox - 1 (3:49)
MsgBox - 2 (6:28)
MsgBox - 3 (1:23)
MsgBox - 4 (2:18)
Excel VBA Macros Quiz #13_1 MSG Box
Excel VBA Macros Quiz #13_2 MSG Box
Excel VBA Tutorials Feedback

ACTIVEX CONTROLS

Form Controls vs ActiveX Controls (3:50)
MouseMove Event w. Appln Statusbar (4:44)
Excel VBA Macros Quiz #14 ACTIVEX CONTROLS

USER FORMS

Introduction (1:03)
User Form - Basics (3:45)
Exercise - Part 1 of 4 (1:44)
Exercise - Part 2 of 4 (6:18)
Exercise - Part 3 of 4 (3:59)
Exercise - Part 4 of 4 (11:23)
Option Button - 1 (5:14)
Option Button - 2 (6:17)
Multi Page - Introduction (1:35)
Multi Page - 1 (5:48)
Multi Page - 2 (3:22)
Multi Page - 3 (6:35)
Check Box 01 (6:39)
Combo Box - Method 1 (2:21)
Combo Box - Method 2 (4:59)
Excel VBA Macros Quiz #15_1 USER FORMS
Excel VBA Macros Quiz #15_2 USER FORMS
Excel VBA Macros Quiz #15_3 USER FORMS
Excel VBA Tutorials Feedback

USER DEFINED FUNCTIONS

UDF Intro 01 (2:57)
UDF Example 1 - ScoreResult with IF END IF (3:54)
UDF Example 2 - CellComments (4:06)
UDF Samples - Series A (4:58)
UDF Samples - Series B (0:59)
Excel VBA Macros Quiz #16 USER DEFINED FUNCTIONS

MIS PROJECTS

Split Workbook (9:12)
Protect - Unprotect Sheets (3:10)
Index of Hyperlinks to all Sheets (5:27)
Extract all Comments of a WorkBook to a new WorkSheet (7:04)
Project- Automate,Comment,Insertion and Extraction (3:54)
Count Cells by Color (3:09)
Combine WorkSheets (7:35)

Case Study

01 Case Study- Intro (1:59)
02 Case Study - Demo (4:11)
03 Create the first UserForm (6:48)
04 Write the first line of code (3:26)
05 VBA code to match Username and Password (5:15)
06 Continue with UserForm (4:43)
07 VBA code for the second UserForm (4:50)
08 Unload and Hide UserForm (2:34)
09 Setting of the third UserForm (8:01)
010 Validation for the third UserForm - Part 1 (2:53)
011 VBA code to enable a button (4:20)
012 Validation for the third UserForm - Part 2 (5:02)
013 VBA code for the third UserForm (7:45)
014 Configuring the Previous button (1:47)
015 Submit Data and hide content in excel sheet (5:11)
016 Capture data from the UserForm (3:47)
017 Create a Table Format (3:29)
018 VBA code to send Email (3:25)
019 Send an Email (2:54)
020 Finishing touch to the project (5:44)
021 Testing the code (3:14)
Excel VBA Tutorials Feedback

"Do…While"

Deleting all numeric characters in an alphanumeric string using "Do While" and Loop Counter

Complete and Continue

Lesson Content Locked

Your session expired. Please sign in again to continue.

Login