by | Released June 2012 | ISBN: 9781771370080

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. Show and hide more Publisher resources Download Example Code

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