Excel VBA Macros Hyperdisambiguated Excel VBA Programming
What you’ll learn
By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
You will fully understand the purpose and syntax of each line of code that you write.
You will not simply be entering lines of code because you have been told they will produce a certain result.
You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.
Requirements
Experienced Excel users who are new to Excel VBA programming.
Description
This is a Udemy best-selleing course. Here is some of the feedback from other students:
“Best intro I’ve seen for a non programmer. Explains key concepts well.” Ron Willett
“Wonderful way of teaching. Shows the full hierarchy of both Excel and VBA objects. Now know the differences.” Bill Malemba
“Concise, thorough, yet repetitive enough to allow the concepts to stick. Love the real-world examples and the emphasis on concepts over code parroting. Best VBA tutorial I’ve found, hands down, bar none – covers top to bottom application/VBA structure which is immensely helpful. Well-organized, all code can be re-visited with provided worksheets…” Dy622
“this is my favourite excel vba course. Lot of exercises, lot of different area is covered, and really explains everything from step 1, not just the how, but the why as well. thanks to the course I understand vba and macros better than ever before.”
…
Excel VBA programming can seem baffling, especially when you don’t fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.
This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language.
During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft’s code completion feature.
Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started.
You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)
Overview
Section 1: 1. Getting Started
Lecture 1 1. Course introduction
Lecture 2 2. Excel VBA overview
Lecture 3 3. The Developer Tab
Lecture 4 4. Macro security
Lecture 5 5. The Visual Basic Editor and Project Explorer
Lecture 6 6. Excel objects and event code
Lecture 7 7. Writing a macro in the VBE
Lecture 8 8. Using the Immediate window
Lecture 9 9. Saving a macro-enabled workbook
Lecture 10 10. The correct way to use the macro recorder
Lecture 11 11. Analysing a recorded macro
Lecture 12 12. Improving a recorded macro
Lecture 13 13. Assigning a macro to a button
Lecture 14 14. Testing a macro on another worksheet
Section 2: 2. Key components of VBA code
Lecture 15 1. The Excel object model
Lecture 16 2. VBA classes and functions
Lecture 17 3. Properties and methods
Lecture 18 4. Data variables
Lecture 19 5. Object variables
Lecture 20 6. Option explicit
Lecture 21 7. Declaring and using constants
Lecture 22 8. Using MsgBox for output
Lecture 23 9. Using MsgBox for input
Lecture 24 10. Using VBA InputBox
Lecture 25 11. Using Application.InputBox
Section 3: 3. VBA Control statements
Lecture 26 1. If statements
Lecture 27 2. If … ElseIf statements
Lecture 28 3. Select Case
Lecture 29 4. For … Next loops
Lecture 30 5. For Each … Next loops
Lecture 31 6. Do … While loops
Lecture 32 7. Do … Until loops
Lecture 33 8. Creating arrays
Lecture 34 9. Dynamic arrays
Lecture 35 10. Utilising arrays
Section 4: 4. Procedures and Functions
Lecture 36 1. Sub Procedures and module level variables
Lecture 37 2. Static variables
Lecture 38 3. Passing parameters
Lecture 39 4. Creating and calling functions
Lecture 40 5. Creating user-defined functions
Section 5: 5. Application Object
Lecture 41 1. Changing and restoring user settings
Lecture 42 2. Application.GetOpenFilename Part 1
Lecture 43 3. Application.GetOpenFilename Part 2
Lecture 44 4. Application.GetSaveAsFilename
Lecture 45 5. Controlling screen updating
Lecture 46 6. Suppressing warning messages
Section 6: 6. Code recognition clinic
Lecture 47 1. Example 1
Lecture 48 2. Example 2
Lecture 49 3. Example 3
Lecture 50 4. Example 4
Lecture 51 5. Example 5
Lecture 52 6. Example 6
Lecture 53 07. Hyper-disambiguation practice
Section 7: 7. Files and Workbooks
Lecture 54 1. Targeting workbooks efficiently
Lecture 55 2. Checking whether a workbook is open
Lecture 56 3. Checking whether several workbooks are open
Lecture 57 4. Checking whether a file exists
Lecture 58 5. Checking whether a folder exists
Lecture 59 6. Deleting files and folders
Lecture 60 7. Processing all files in folder
Section 8: 8. Worksheets and charts
Lecture 61 1. Targeting worksheets efficiently
Lecture 62 2. Copying worksheets
Lecture 63 3. Moving worksheets between workbooks
Lecture 64 4. Saving worksheets as separate workbooks
Lecture 65 5. Working with the sheets collection
Lecture 66 7. Creating an embedded chart
Lecture 67 6. Creating a standalone chart
Section 9: 9. The Range object
Lecture 68 1. Copying a range of cells
Lecture 69 2. Using the Offset property
Lecture 70 3. The End property
Lecture 71 4. The Resize property
Lecture 72 5. Entering formulas with VBA
Lecture 73 6. Deleting ranges
Lecture 74 7. Inserting ranges
Lecture 75 8. Outlining ranges
Anyone wishing to learn professional Excel VBA programming techniques.
Course Information:
Udemy | English | 11h 42m | 7.36 GB
Created by: Grant Gamble
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com