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/
Смотрите видео Excel VBA Tutorial for Beginners: A Step-by-Step Guide онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Coding Module 04 Май 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,309 раз и оно понравилось 38 людям.