Learn how to write VBA code, even if you're a complete beginner!
This first course focuses on how to create Subs, Functions, and goes over Strings, Long integers, and the MSGBOX command.
Configure your VBA editor: ua-cam.com/video/g2Su14sxnBs/v-deo.html
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