Visual Basic for Microsoft Excel

Video description

In this VB for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.
Guy extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.
By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn VBA for Microsoft Excel in this video tutorial.

Table of contents

  1. Getting Started
    1. What Will I Get Out Of This Course
    2. About The Author
    3. The Working Files Explained
    4. What Is VBA?
    5. Excel 2010 Security Settings And Macro Files
    6. The Developer Ribbon
  2. Macros
    1. Recording And Running A Simple Macro
    2. Editing An Existing Macro In The Visual Basic Editor
    3. The New Macro Enabled File Type
    4. Quick Tour Of The Visual Basic Editor
    5. Watch A Macro Write Your VBA
  3. Procedures And Functions
    1. What Is A Module?
    2. Creating A Sub Procedure Manually
    3. How To Call A Sub Procedure
    4. Creating A Function Procedure
    5. How To Call A Function
  4. Getting Started With VBA Programming
    1. Using Comments Within Your VBA Code
    2. Declaring Variables And Data Types
    3. The Scope Of A Variable
    4. The Static Declaration And Variable Expiry
    5. Constants Instead Of Variables
    6. An Intrinsic Constant
    7. String And Date Types Expanded
    8. VBA Operators
    9. Arrays
    10. Multi-Dimensional Arrays
    11. Dynamic Arrays
  5. Manipulating Excel Objects
    1. Referencing Cells Using The Range Object
    2. The CELLS Property
    3. The OFFSET Property
    4. The VALUE Of Ranges
    5. The TEXT Object Of The RANGE
    6. A Number Of Read Only RANGE Properties
    7. The FONT Property And Colors
    8. Formatting Numeric Values
    9. Add Formulas To Cells Through VBA Code
    10. Common METHODS Of The RANGE Object
  6. Working With Excel VBA Functions
    1. What Is A Function?
    2. Built In VBA Date Functions
    3. Text Manipulation With VBA Functions
    4. Determining File Sizes Using FILELEN
    5. Using Worksheet Excel Functions In VBA Code
    6. User Defined Functions
  7. Controlling Program Flow And Execution
    1. Using GOTO And Labels
    2. Controlling The Program Flow With IF THEN ELSE
    3. Multiple Criteria Plus Nested IFs
    4. Adding ELSEIF To Speed Up Execution
    5. SELECT CASE As An Alternative To IF
    6. The FOR NEXT Loop
    7. FOR NEXT With A VBA Collection
    8. DO WHILE Loop
  8. Events
    1. How To Create An Event
    2. WorkBook Events - Open
    3. Workbook Events - Closing And Saving
    4. Workbook Triggers - Activate And Deactivate
    5. Worksheet Triggers - Activate And Deactivate
    6. Other Useful Worksheet Triggers
    7. Using Application Events
  9. Debugging And Error Handling
    1. Error Trapping the Easy Way
    2. Make The VBA Ignore Errors
    3. Interact With The User When An Error Occurs
    4. Making Use Of The ERR Object
    5. Debugging Techniques
    6. Using Breakpoints To Help Debug
    7. Setup And Use A Watch
    8. Speeding Up The VBA Tips
  10. Interacting With Users Through Forms
    1. Using MSGBOX To Interact With Users
    2. Use INPUTBOX For Accepting Values From Users
    3. Selecting A Range With The INPUT Box
    4. An Introduction To UserForms
    5. Creating A UserForm
    6. Using Command Buttons
    7. Adding Option Buttons In A Frame
    8. Adding The Code That Makes The Form Work
    9. Calling Your UserForm And Validating Content
    10. UserForm Controls - The CheckBox
    11. UserForm Controls - ListBox And/Or Combo Box
    12. Images On UserForms
    13. Labels And Text Boxes
    14. Multiple Tabs On A UserForm
    15. Allowing The User To Highlight A Range
    16. Scrollbar And Spin Controls
    17. Controlling Tab Order And Aligning Controls
  11. Running And Storing VBA Code
    1. Trigger A Procedure From The Quick Access Toolbar
    2. Customizing The Ribbons
    3. Adding Buttons To Sheets
    4. Adding A Keyboard Shortcut Trigger
    5. Where To Store Your VBA Code
    6. Adding Code To The PERSONAL File
  12. Summary
    1. So What's Next?

Product information

  • Title: Visual Basic for Microsoft Excel
  • Author(s):
  • Release date: June 2012
  • Publisher(s): Infinite Skills
  • ISBN: 9781771370080