Beginner Excel VBA tutorial / Access VBA Tutorial - Learn how to write simple code - Part 1

Learn how to write VBA code, even if you're a complete beginner! This first course focuses on how to create Subs, and Functions. It introduces the String variable, Long integer variable, and the MSGBOX command. Tutorial #2 - https://youtu.be/_p-i10qW9oE Tutorial #3 - https://youtu.be/dVhU9w3jlL8 Configure your VBA editor: https://youtu.be/g2Su14sxnBs Google sheets with module code for Access and Excel: https://docs.google.com/spreadsheets/d/1dHc6Om6THcN9DJTHcKCxuiMJYtPAg_4TSwBYIT8W98M/edit?usp=drive_link 00:00-00:09 Welcome 00:09-00:53 Set up your Excel file 01:03 - 01:15 Ensure correct project 01:15 - 01:44 Set up editor environment 01:44 - 03:23 Basic MsgBox operations 03:23 - 06:03 String introduction 06:03 - 08:10 String Concatenate 08:10 - 08:35 VBCR command 08:35 - 10:33 Intro to Long Int and concatenate 10:33 - 13:49 More examples of Msgbox arguments 13:49 - 15:00 Intro to Long Int math 15:00 - 15:52 Errors if you try to add string to int 15:52 - 16:09 When you can add strings to numbers 16:09 - 16:35 Errors if you try to append a string to a long 16:35 - 16:50 Practical Exercise 1 16:50 - 17:36 One reason to use variables 17:36 - 19:59 Intro to functions 19:59 - 22:39 Practical Ex 2, then answers to both