Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Learning Visual Basic for Microsoft Excel

    Subscriber Reviews • Browse Similar Topics

    Overview

    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.

    Subscriber Reviews

    Average Rating: 3.75 out of 5 rating Based on 4 Ratings

    No Subscribers have provided a review for this video.

    Table of Contents

    Chapter/Selection

    Time

    01. Getting Started

    What Will I Get Out Of This Course

    Preview

    00:03:56

    About The Author

    Preview

    00:01:16

    The Working Files Explained

    Preview

    00:03:00

    What Is VBA?

    Preview

    00:05:07

    Excel 2010 Security Settings And Macro Files

    Play Video

    00:03:43

    The Developer Ribbon

    Preview

    00:01:54

    02. Macros

    Recording And Running A Simple Macro

    Preview

    00:03:51

    Editing An Existing Macro In The Visual Basic Editor

    Preview

    00:03:59

    The New Macro Enabled File Type

    Preview

    00:02:21

    Quick Tour Of The Visual Basic Editor

    Play Video

    00:06:00

    Watch A Macro Write Your VBA

    Preview

    00:02:58

    03. Procedures And Functions

    What Is A Module?

    Preview

    00:03:18

    Creating A Sub Procedure Manually

    Preview

    00:03:14

    How To Call A Sub Procedure

    Preview

    00:02:49

    Creating A Function Procedure

    Preview

    00:02:51

    How To Call A Function

    Preview

    00:02:56

    04. Getting Started With VBA Programming

    Using Comments Within Your VBA Code

    Preview

    00:03:58

    Declaring Variables And Data Types

    Play Video

    00:05:29

    The Scope Of A Variable

    Preview

    00:04:49

    The Static Declaration And Variable Expiry

    Preview

    00:04:53

    Constants Instead Of Variables

    Preview

    00:03:39

    An Intrinsic Constant

    Preview

    00:03:07

    String And Date Types Expanded

    Play Video

    00:06:04

    VBA Operators

    Preview

    00:07:50

    Arrays

    Preview

    00:05:07

    Multi-Dimensional Arrays

    Preview

    00:03:32

    Dynamic Arrays

    Preview

    00:03:22

    05. Manipulating Excel Objects

    Referencing Cells Using The Range Object

    Play Video

    00:05:28

    The CELLS Property

    Preview

    00:02:45

    The OFFSET Property

    Preview

    00:02:29

    The VALUE Of Ranges

    Preview

    00:07:43

    The TEXT Object Of The RANGE

    Preview

    00:03:01

    A Number Of Read Only RANGE Properties

    Preview

    00:09:06

    The FONT Property And Colors

    Preview

    00:08:20

    Formatting Numeric Values

    Preview

    00:03:24

    Add Formulas To Cells Through VBA Code

    Play Video

    00:06:36

    Common METHODS Of The RANGE Object

    Preview

    00:11:46

    06. Working With Excel VBA Functions

    What Is A Function?

    Preview

    00:01:30

    Built In VBA Date Functions

    Preview

    00:02:29

    Text Manipulation With VBA Functions

    Preview

    00:03:52

    Determining File Sizes Using FILELEN

    Preview

    00:02:34

    Using Worksheet Excel Functions In VBA Code

    Play Video

    00:08:09

    User Defined Functions

    Preview

    00:04:35

    07. Controlling Program Flow And Execution

    Using GOTO And Labels

    Preview

    00:04:25

    Controlling The Program Flow With IF THEN ELSE

    Play Video

    00:04:23

    Multiple Criteria Plus Nested IFs

    Preview

    00:05:27

    Adding ELSEIF To Speed Up Execution

    Preview

    00:04:07

    SELECT CASE As An Alternative To IF

    Preview

    00:04:24

    The FOR NEXT Loop

    Play Video

    00:09:25

    FOR NEXT With A VBA Collection

    Preview

    00:06:32

    DO WHILE Loop

    Preview

    00:06:56

    08. Events

    How To Create An Event

    Preview

    00:06:57

    WorkBook Events - Open

    Preview

    00:08:17

    Workbook Events - Closing And Saving

    Preview

    00:07:31

    Workbook Triggers - Activate And Deactivate

    Preview

    00:05:12

    Worksheet Triggers - Activate And Deactivate

    Preview

    00:04:15

    Other Useful Worksheet Triggers

    Preview

    00:09:44

    Using Application Events

    Preview

    00:12:06

    09. Debugging And Error Handling

    Error Trapping the Easy Way

    Preview

    00:07:38

    Make The VBA Ignore Errors

    Play Video

    00:04:12

    Interact With The User When An Error Occurs

    Preview

    00:04:58

    Making Use Of The ERR Object

    Preview

    00:04:14

    Debugging Techniques

    Preview

    00:06:11

    Using Breakpoints To Help Debug

    Preview

    00:05:45

    Setup And Use A Watch

    Preview

    00:05:04

    Speeding Up The VBA Tips

    Play Video

    00:12:50

    10. Interacting With Users Through Forms

    Using MSGBOX To Interact With Users

    Preview

    00:09:05

    Use INPUTBOX For Accepting Values From Users

    Preview

    00:07:19

    Selecting A Range With The INPUT Box

    Preview

    00:04:04

    An Introduction To UserForms

    Preview

    00:04:06

    Creating A UserForm

    Play Video

    00:04:22

    Using Command Buttons

    Preview

    00:05:17

    Adding Option Buttons In A Frame

    Preview

    00:05:12

    Adding The Code That Makes The Form Work

    Preview

    00:07:17

    Calling Your UserForm And Validating Content

    Preview

    00:08:05

    UserForm Controls - The CheckBox

    Preview

    00:08:10

    UserForm Controls - ListBox And/Or Combo Box

    Play Video

    00:10:10

    Images On UserForms

    Preview

    00:05:24

    Labels And Text Boxes

    Preview

    00:05:30

    Multiple Tabs On A UserForm

    Preview

    00:08:10

    Allowing The User To Highlight A Range

    Preview

    00:04:13

    Scrollbar And Spin Controls

    Preview

    00:08:17

    Controlling Tab Order And Aligning Controls

    Preview

    00:08:48

    11. Running And Storing VBA Code

    Trigger A Procedure From The Quick Access Toolbar

    Preview

    00:05:05

    Customizing The Ribbons

    Preview

    00:05:06

    Adding Buttons To Sheets

    Preview

    00:03:51

    Adding A Keyboard Shortcut Trigger

    Preview

    00:02:45

    Where To Store Your VBA Code

    Preview

    00:07:38

    Adding Code To The PERSONAL File

    Preview

    00:08:09

    12. Summary

    So What's Next?

    Preview

    00:02:27

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    These files have been provided by the publisher.

    • Working_Files.zip