Excel VBA Course

$39.95

This Complete Excel VBA Course was created by professional Excel developers and covers Excel VBA and Excel UserForms. It includes 20 lessons with 5 Excel workbook examples, along with a Downloadable Microsoft Excel Solutions book with hundreds of solutions to Excel problems .  Sold on MyCommerce.

Buy Now

Description

This Excel VBA Course was created by professional Excel developers with over 20 years experience. Each lesson is focused on real life solutions that Excel users can apply every day.  This comprehensive course is a must-have for developing and automating Excel with VBA code!

This product is sold on our MyCommerce store.

What You Get

  • 20 lessons each 5-10 pages with 5 Excel VBA workbook examples
  • Complete Excel VBA course covering everything from VBA fundamentals to coding to error handling
  • Downloadable Microsoft Excel Solutions book in Windows help file format that contains hundreds of solutions to Excel problems.
  • Excel VBA Userforms course

Details of Excel VBA Course

  • Fundamentals of Excel VBA: Visual Basic Editor, Objects and Properties
  • Excel VBA Objects: Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars, Variables and Constants, Data types
  • Excel VBA Variables:  Variable Levels, Declaring Variables, Constants
  • Excel VBA Loops: Types of Loops, Loop Pitfalls
  • Excel VBA Decision Logic: If, And, Or, Select Case
  • Excel VBA Dates and Times
  • Excel VBA Workbook and Worksheet Events
  • VBA Debugging and Error Handling: Prevention, Good Habits, Runtime Errors
  • Using Excel Worksheet Functions in VBA
  • User Defined Functions, Good vs Bad, Arguments, Calculations
  • Excel VBA Controls: ActiveX, Control Toolbox, Control Properties, Control Parent

Details of Excel UserForms Course

  • Excel UserForms Introduction
  • Filling UserForm Controls: Entering Data into Controls,  Filling a ListBox or ComboBox, Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime
  • Using Loops with Excel UserForms
  • Multi-Page Controls: Creating a wizard using the Multi-Page Control, Validating the User Inputs
  • Useful Methods and Functions
  • UserForm Validation: Control Events, Which Controls to use
  • Parsing UserForm Data:  Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls
  • UserForm Options: Buttons, Checkboxes, Details, True / False