30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Microsoft Visual Basic for Excel Tutorial

A professionally created, self-study video training course
Includes 8 hours of easy to follow Microsoft Visual Basic for Excel video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft Visual Basic for Excel tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 8 hours
  • Video lessons: 90
  • Product code: 01698
  • In stock: YES
Get to grips with applying the VBA programming language to increase the capabilities of your Excel spreadsheets with the help of these Microsoft Visual Basic for Excel Tutorial videos.

Commencing from the absolute basics, expert tutor Guy Vaccaro uses step-by-step training videos that help explain and demonstrate the important concepts ensuring that by the conclusion of this course, you will have a sound knowledge of the VBA programming language and be fully capable of applying this to create interactive and fully functional spreadsheets.

Through over eight hours of professionally created training videos, the tuition includes the basics of the Visual Basic Editor, Macro Files explained, lessons on procedures and functions, learning MS Excel VBA functions, help with Events and so much more.
The same work files that Guy uses are also included in the DVD / Online purchase, which allows you to easily replicate the on-screen actions and effortlessly keep pace with his verbal instructions.

The complete training course contents are listed below and you can start learning MS VBA for Excel right away, click any of the blue linked lessons to sample FREE Visual Basic for Excel video tutorials and discover how effective this teaching method is...
What Our Customers Are Saying

"By the way I did try one of your sample demos and I really like how the lessons are presented, LOVE the background info provided on the lesson. I am a 'Dinosaur' in this business that needs to retrain, (darn!) and I was able to follow the instructor no problem. Thanks."Mayra Rosas, Indiana
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Getting Started
What Will I Get Out Of This Course
About The Tutor
The Working Files Explained
What Is VBA?
MS Excel 2010 Security Settings And Macro Files
The Developer Ribbon

Macros
Recording And Running A Simple Macro
Editing An Existing Macro In The Visual Basic Editor
The New Macro Enabled File Type
Quick Tour Of The Visual Basic Editor
Watch A Macro Write Your VBA

Procedures And Functions
What Is A VB Module?
Creating A Sub Procedure Manually
How To Call A Sub Procedure
Creating A Function Procedure
How To Call A Function

Getting Started With VBA Programming
Using Comments Within Your VBA Code
Declaring Variables And Data Types
The Scope Of A Variable
The Static Declaration And Variable Expiry
Constants Instead Of VB Variables
An Intrinsic Constant
String And Date Types Expanded
VBA Operators
Arrays
Multi-Dimensional Arrays
Dynamic Arrays

Manipulating Excel Objects
Referencing Cells Using The Range Object
The CELLS Property
The OFFSET Property
The VALUE Of Ranges
The TEXT Object Of The RANGE
A Number Of Read Only RANGE Properties
The FONT Property And Colors
Formatting Numeric Values
Add Formulas To Cells Through VBA Code
Common METHODS Of The RANGE Object

Working With Excel VBA Functions
What Is A Function?
Built In VBA Date Functions
Text Manipulation With VBA Functions
Determining File Sizes Using FILELEN
Using Worksheet Excel Functions In VBA Code
User Defined Functions

Controlling Program Flow And Execution
Using GOTO And Labels
Controlling The Program Flow With IF THEN ELSE
Multiple Criteria Plus Nested IFs
Adding ELSEIF To Speed Up Execution
SELECT CASE As An Alternative To IF
The FOR NEXT Loop
FOR NEXT With A VBA Collection
DO WHILE Loop

Events
How To Create An Event
WorkBook Events - Open
Workbook Events - Closing And Saving
Workbook Triggers - Activate And Deactivate
Worksheet Triggers - Activate And Deactivate
Other Useful Worksheet Triggers
Using Application Events

Debugging And Error Handling
Error Trapping the Easy Way
Make The VBA Ignore Errors
Interact With The User When An Error Occurs
Making Use Of The ERR Object
Debugging Techniques
Using Breakpoints To Help Debug
Setup And Use A Watch
Speeding Up The VBA Tips

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
Trigger A Procedure From The Quick Access Toolbar
Customizing The Ribbons
Adding Buttons To Sheets
Adding A Keyboard Shortcut Trigger
Where To Store Your VBA Code
Adding Code To The PERSONAL File

Summary
So What's Next?
Excel VBA Course End
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
 
Item(s):
   
Once purchased, you will receive 90 Microsoft Visual Basic for Excel training videos (listed left), lasting a total of 8 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This Microsoft Visual Basic for Excel course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft Visual Basic for Excel course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
PRICE
(Per 10 user concurrent licence)
Closely Related Courses
See our complete range of Microsoft Office 2013 Tutorials
See our complete range of Microsoft Visual Basic Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft Visual Basic for Excel. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"By the way I did try one of your sample demos and I really like how the lessons are presented, LOVE the background info provided on the lesson. I am a 'Dinosaur' in this business that needs to retrain, (darn!) and I was able to follow the instructor no problem. Thanks."Mayra Rosas, Indiana