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/folders/1G6XhzIzAVjn9hblrf69KK8jMII8wr3hE?usp=sharing Comments.xlsm https://drive.google.com/drive/folders/1G6XhzIzAVjn9hblrf69KK8jMII8wr3hE?usp=sharing sampledatafootballplayers.xlsx https://drive.google.com/drive/folders/1G6XhzIzAVjn9hblrf69KK8jMII8wr3hE?usp=sharing SeleniumBasic Installer for VBA https://github.com/florentbr/seleniumbasic/releases Chrome Webdriver https://chromedriver.chromium.org/home Selenium Documentation https://www.selenium.dev/documentation/