Excel VBA Programming

Try Before You Buy Options:

  1. Watch Intro Video
  2. Free Trial
$75.00
SKU
Excel VBA Programming

Course description

The video tutorials in this course will show you how to automate Microsoft Excel tasks and operations. It is aimed particularly at Excel users, without much programming experience, who struggle to remember the syntax and structure of the VBA 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, 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.)


COURSE  CURRICULUM

Getting Started
  1. Course introduction
  2. Excel VBA overview
  3. The Developer Tab
  4. Macro security
  5. The Visual Basic Editor and Project Explorer
  6. Excel objects and event code
  7. Writing a macro in the VBE
  8. Using the Immediate window
  9. Saving a macro-enabled workbook
  10. The correct way to use the macro recorder
  11. Analysing a recorded macro
  12. Improving a recorded macro
  13. Assigning a macro to a button
  14. Testing a macro on another worksheet
Key Components of VBA Code
  • The Excel object model
  • VBA classes and functions
  • Properties and methods
  • Data variables
  • Object variables
  • Option explicit
  • Declaring And Using Constants
  • Using MsgBox for Output
  • Using MsgBox for Input
  • Using VBA InputBox
  • Using Application.InputBox
VBA Control Statements
  1. If Statements
  2. If … ElseIf Statements
  3. Select Case
  4. For … Next Loops
  5. For Each … Next Loops
  6. Do … While Loops
  7. Do … Until Loops
  8. Creating Arrays
  9. Dynamic Arrays
  10. Utilising Arrays
Procedures and Functions
  1. Sub Procedures and Module Level Variables
  2. Static Variables
  3. Passing Parameters
  4. Creating and Calling Functions
  5. Creating User-defined Functions
The Application Object
  1. Changing and Restoring User Settings
  2. Application.GetOpenFilename
  3. Application.GetSaveAsFilename
  4. Controlling Screen Updating
  5. Suppressing Warning Messages
Code Recognition Clinic
  1. Example 1
  2. Example 2
  3. Example 3
  4. Example 4
  5. Example 5
  6. Example 6
  7. Hyper-disambiguation Practice
Files and Workbooks
  • Targeting Workbooks Efficiently
  • Checking Whether A Workbook Is Open
  • Checking Whether Several Workbooks Are Open
  • Checking Whether A File Exists
  • Checking Whether A Folder Exists
  • Deleting Files And Folders
  • Processing All Files In Folder
Worksheets and Charts
  1. Targeting Worksheets Efficiently
  2. Copying Worksheets
  3. Moving Worksheets Between Workbooks
  4. Saving Worksheets As Seperate Workbooks
  5. Working With The Sheets Collection
  6. Creating A Standalone Chart
  7. Creating An Embedded Chart
The Range Object
  1. Copying A Range Of Cells
  2. Ysing The Offset Property
  3. The End Property
  4. The Resize Property
  5. Entering Formulas With VBA
  6. Deleting Ranges
  7. Inserting Ranges
  8. Outlining Ranges

.

Write Your Own Review
You're reviewing:Excel VBA Programming