Excel VBA Tutorial for Beginners: A Step-by-Step Guide
Must-Know Excel VBA Macros for Productivity
Mastering Excel VBA User-Defined Functions
How to Automate Excel Tasks with VBA
Creating Custom Excel VBA Forms and Controls
How to Automate Web Applications with VBA
Course Outline
00:00:15 Course Outline
00:01:56 Introduction
00:02:33 Setting up your coding environment
00:03:20 VBA Editor
VBA Basics
00:03:53 Immediate Window
00:04:31 Printing Value in the Immediate Window
00:05:48 Expressions
00:07:26 Precedence (Order of Operations)
00:09:16 String Concatenation
00:10:47 Variables
00:11:33 Assignment Statement
00:12:18 Module
00:13:11 Procedure
00:13:44 My First Program
00:18:55 Exercise No. 1
Flow Control
00:19:01 Flow Control
00:19:20 Boolean Values
00:19:42 Comparison Operators
00:21:50 Boolean Operators
00:22:27 Conditions
00:23:18 If, Elseif, and Else Statements
00:26:46 Exercise No. 2
00:26:52 Loop
00:27:07 Do While Loop
00:28:58 For Next Loop
00:31:11 Do Until Loop
00:32:32 Exit Do and Exit For Statements
00:34:44 Exercise No. 3
00:34:49 Random Function (RND)
00:36:43 Guess the Number
Function and Exception Handling
00:44:17 Function
00:49:13 Exercise No. 4
00:49:18 Exception Handling
00:52:39 Exercise No. 5
Excel Sheet and VBA
00:52:45 Read Value from Excel using VBA
00:53:38 Application, Workbook, Worksheet, Range, and Cell
00:58:45 Workbook and Worksheet Variable
01:00:33 With Statement
01:02:26 Write Value to Excel using VBA
01:04:17 Calling a procedure from a button or shape
01:06:29 Transfer Data between two worksheets
01:16:50 Copy Data from Another Excel or Workbook
01:24:31 Application.ScreenUpdating
01:29:27 Application.GetOpenFileName
01:32:06 Copy Matching Records from Another Excel or Workbook
01:48:16 Exercise No. 6
01:49:09 String Manipulation
01:53:02 LEN function
01:54:46 INSTR function
01:59:08 LEFT function
02:00:51 RIGHT function
02:02:37 MID function
02:05:35 Exercise No. 7
Excel VBA User Form
02:05:40 User Form
02:09:21 Background Color
02:09:33 Label Control
02:12:11 Command Button Control
02:13:20 Listbox Control (Multi Column with Header)
02:17:13 Textbox Control
02:18:59 Frame Control
02:19:37 Option Button Control
02:20:33 ComboBox Control
02:24:02 How to Add VBA Code to Form Control
02:24:18 User Form Events
02:29:44 Adding Options to ComboBox Controls
02:37:42 Setting Lisbox Control Row Source Property
VBA and Selenium
02:44:38 Selenium Introduction
02:44:46 Selenium and Webdriver Installation
02:48:06 Selenium: RPA Challenge Movies
03:07:17 Selenium: Fake Name Generator
RPA and Excel VBA Projects
https://codingmodule.com/
Links and Resources
SampleData.xlsx
https://drive.google.com/drive/folder...
Comments.xlsm
https://drive.google.com/drive/folder...
sampledatafootballplayers.xlsx
https://drive.google.com/drive/folder...
SeleniumBasic Installer for VBA
https://github.com/florentbr/selenium...
Chrome Webdriver
https://chromedriver.chromium.org/home
Selenium Documentation
https://www.selenium.dev/documentation/
Watch video Excel VBA Tutorial for Beginners: A Step-by-Step Guide online without registration, duration hours minute second in high quality. This video was added by user Coding Module 04 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,309 once and liked it 38 people.