The Best VBA Course For Absolute Beginners - Part 1
This video is the first in a series that is designed to help the absolute beginner learn to create their first VBA macro in Excel. The course has been specifically designed to minimize the complexity of the code to ensure that it is accessible to all.
In this first video we will be covering how to set up Excel for coding VBA which is simple to do and you will learn to create your first macro and use the message box command. Additionally, you will learn how to insert values into a spreadsheet using code. For more information visit bernieslearnings.com.
Code From The Video:
Sub My_First_Macro()
'Command for Message Box for Text
MsgBox "Hello World"
'Command for Message Box for Text
MsgBox 1
'Command for Message Box for Text and Number
MsgBox "Hello World" & " " & 5
End Sub
Sub Second_Macro()
Worksheets("Sheet1").Range("A1") = 6
Worksheets("Sheet1").Cells(1, "A") = 8
MsgBox "The value cell A1 is " & Worksheets("Sheet1").Range("A1")
End Sub
Watch video The Best VBA Course For Absolute Beginners - Part 1 online without registration, duration hours minute second in high quality. This video was added by user Excel At Bernie's Learnings 12 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 115 once and liked it 0 people.