The Best VBA Course For Absolute Beginners - Part 1

Опубликовано: 12 Ноябрь 2022
на канале: Excel At Bernie's Learnings

115

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

Смотрите видео The Best VBA Course For Absolute Beginners - Part 1 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel At Bernie's Learnings 12 Ноябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 115 раз и оно понравилось 0 людям.

15,362

115