Excel VBA Introducing The Visual Basic Editor, And Recording Our First Macro
• Excel VBA Introducing The Visual Basi... - Excel VBA Introducing The Visual Basic Editor, And Recording Our First Macro
In this lecture we will take a look at the Visual Basic Editor (VBE)...this is the environment where you will write, and modify your VBA code.
I'll show you how add the developer ribbon, if it's not already visible, which is one of the ways to access the VBE. The other, and by far the quickest, is to use the keyboard shortcut ALT + F11.
We will go through how to record our first macro (a macro is just a recorded sequence of keystrokes) in 3 different ways.
1. From the Developer ribbon (record a macro)
2. From the View ribbon (record a macro)
3. Click the "record" button to the bottom left of the screen.
We will talk about the naming conventions for what to call your macros...(hint: call them something descriptive!).
Once we've recorded a simple macro, we will go "under the hood", and back into the VBE and take a look at the VBA code we just created!
All macros begin with the word "Sub" and always end with the words "End Sub".
In the VBA programming language, some words are reserved...that is, they have special meaning and do specific things. You can spot these words easily, because they always auto-capitalise and they are also in a blue typeface.
You will also see some of the writing in a green typeface...these are REMarks...remember the 15 Golden Rules of Coding? The are just notes we can add for our own convenience.
Finally, we have writing in black typeface...this is the "Executable" code...this is the stuff that actually does the good stuff!
Finally, we will take a look at a few ways to execute, or "run" your code.
This is a sample lecture from my course, Microsoft Excel Essentials: Level 3 - VBA Programming. This course is for Excel 2007, Excel 2010, Excel 2013 and Excel 2016, 2019 and 365
Get this course now!
Level 1: Microsoft Excel Essentials: Level 1 Basics - Excel Made Easy
The complete 4 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-ess...
Level 2: Microsoft Excel Essentials: Level 2 - Intermediate/Advanced
The complete 9 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-ess...
Level 3: Microsoft Excel Essentials: Level 3 - VBA Programming + Macros
The complete 13.5 hour course is yours for a low cost monthly subscription (first 2 months free!): https://www.alangjarvis.com/excel-ess...
Alternatively, you can purchase the complete set in...
Excel Essentials: The Complete Excel Series - Level 1, 2 & 3
The WHOLE 27.5 Hour Excel Mastery Series In One! From Excel Novice To VBA Programmer...
Available to buy with lifetime access for just $16.99 (normally $200) here:
https://www.alangjarvis.com/excel-ess...
This course is for suitable Excel 2007, Excel 2010, Excel 2013, 2016, 2019 & 365
Videos in the Level 1 series:
• Opening Excel, And Creating A Desktop...
• The Anatomy Of An Excel Workbook
• What's Where In Excel In 5 Minutes
• Always Do This First In Excel...Save ...
• Entering Data In Excel
• Editing Data In Excel
• What To Do If You Make A Mistake In E...
• Reverse Engineering A Sample Spreadsh...
• Casing And Text Functions In Excel
Videos in the Level 2 series:
• Excel: Proof Of Concept (excel view 2...
• Excel: Planning Ahead
• Creating A Data Entry Screen In Excel
• Custom Formatting Dates And Times In ...
• Simple Calculations With Time In Excel
• More (Useful) Calculations With Time ...
• It's About Time (And Dates) In Excel
• Excel Calls Text Data - Or How To Ret...
• Excel Calls Text Data 2 - This Time U...
• Excel Extracting Phone Numbers From A...
• Excel What Is The CHOOSE Function Re...
• Excel Dynamic Charting From A Drop Down
• Excel Extracting a Unique List, And S...
• Excel SUMIF With Dynamic Sum Range
• Excel VLOOKUPs With Pictures!
Videos in the Level 3 series:
• Excel VBA Why Should I Learn How To Code
• Excel VBA The 15 Golden Rules Of Coding
• Excel VBA Introducing The Visual Basi...
• Excel VBA Saving Macro-enabled Workbo...
• Excel VBA Moving VBA Code Around
• Excel VBA Stepping Out. Well, In Actu...
• Excel VBA Introduction To The Coding ...
• Excel VBA Introduction To Programmers...
• Excel VBA Introduction To Automating ...
• Excel VBA Introduction To Web Query S...
• Excel VBA Introduction To The VBA Wor...
• Excel VBA Introduction To The VBA Win...
• Excel VBA Introduction To Automating ...
• Excel VBA Introduction To Automating ...
• Excel VBA Introduction To Automating ...
• Excel VBA Calling A Sub Stored In A D...
• Excel VBA Introduction To The Mass Da...
• Excel VBA Get Rid Of Rows In An Array...
• Excel VBA Emailing Routine Adding a S...
• Excel VBA Adding A Date Stamp, And Go...
• Excel VBA Saving An Individual Sheet ...
• Excel VBA Saving Multiple Sheets To A...
• Excel VBA Animated Charts...With A Li...
• Excel VBA Extracting Specific Data Fr...
• Excel VBA Finding A Search String in ...
Смотрите видео Excel VBA Introducing The Visual Basic Editor, And Recording Our First Macro онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Alan Jarvis 09 Сентябрь 2017, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 520 раз и оно понравилось 3 людям.