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
- Getting Started
- Macros
- Procedures And Functions
- Getting Started With VBA Programming
- Manipulating Excel Objects
- Working With Excel VBA Functions
- Controlling Program Flow And Execution
- Events
- Debugging And Error Handling
-
Interacting With Users Through Forms
- Using MSGBOX To Interact With Users
- Use INPUTBOX For Accepting Values From Users
- Selecting A Range With The INPUT Box
- An Introduction To UserForms
- Creating A UserForm
- Using Command Buttons
- Adding Option Buttons In A Frame
- Adding The Code That Makes The Form Work
- Calling Your UserForm And Validating Content
- UserForm Controls - The CheckBox
- UserForm Controls - ListBox And/Or Combo Box
- Images On UserForms
- Labels And Text Boxes
- Multiple Tabs On A UserForm
- Allowing The User To Highlight A Range
- Scrollbar And Spin Controls
- Controlling Tab Order And Aligning Controls
- Running And Storing VBA Code
- Summary
Product information
- Title: Visual Basic for Microsoft Excel
- Author(s):
- Release date: June 2012
- Publisher(s): Infinite Skills
- ISBN: 9781771370080
You might also like
video
Visual Basic For Microsoft Access
In this software training course from expert author and trainer Guy Vaccaro, you will learn how …
book
Excel VBA Programming For Dummies, 5th Edition
Take your Excel programming skills to the next level To take Excel to the next level, …
book
VBA and Macros for Microsoft Excel
Everyone is looking for ways to save money these days. That can be hard to do …
video
Microsoft Excel - Shortcut Guide
In this Microsoft Excel – Shortcut Guide training course, expert author Guy Vaccaro takes you beyond …