Introduction to Microsoft Visual Basic -
Course
In Royal Leamington Spa
Learn Microsoft Visual Basic essentials!
-
Type
Course
-
Methodology
Inhouse
-
Location
Royal leamington spa
-
Duration
2 Days
-
Start date
Different dates available
This course is designed for delegates who have little or no knowledge of Visual Basic and are seeking to develop code for use within Microsoft
Excel workbooks. It should give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, event handling, control structures, and debugging tools.
Facilities
Location
Start date
Start date
About this course
This course is designed for delegates who have little or no knowledge of Visual Basic. Delegates should be seeking to develop macro code for use
within workbooks, so allowing for simple and accurate validated input of data, processing of repetitive tasks, importing of information and creating their own functions.
A thorough knowledge of Excel’s main features and shortcuts through experience or advanced training prior to this course is essential. Be able to
navigate, edit and manage Excel workbooks. Format worksheets and workbooks. Understand the difference between absolute and relative references, understand the basics of Excel formulas and functions, understand the concepts of a Macro and its capabilities
Reviews
Subjects
- Microsoft Project
- Excel
- Word
- Powerpoint
- Basic
- Visual Basic training
- Microsoft Visual Basic
- Microsoft Excel
- Microsoft Word
- Microsoft Powerpoint
- Computer Engineering
- Visual Basic
- IT Security
- IT Systems
- Computer Science
- Office systems
- IT
- Computering
- Microsoft
- Mirosoft Access
Course programme
Getting Started
• Introduce Visual Basic for Applications
• Record and Run a Macro
• Absolute or Relative Cell Referencing
• Save and Open Files with Macros
• Edit a Macro in the Visual Basic Editor
• Understand the Development Environment
• Tips for General Typing in VBA
• Use the Visual Basic Help
• Assign Macros to Keyboard Shortcuts, Quick Access Toolbar
and Buttons
Working with Procedures
• Program Design
• Understand and Create Modules
• Understand Procedures
• Program Macro Concepts
• Create a Subroutine and a Function
• Understand Arguments
• Exit and Calling Procedures
Understand Objects, Properties, Methods and Events
• Understand Objects Properties, Methods, Events
• Navigate the Object Hierarchy
• Understand Collections
• Use the Object Browser
• Use the With Statement
• Work with Properties and Methods
• Create an Event Procedure
Controlling Program Execution For Next
• Understand Control-of-Flow Structures
• Use the If...End If Decision Structures
• Use the Select Case ...End Select Structure
• Use the Do ...Loop Structure
• Use the For ...Next Structure
• Use the For Each ...Next Structure
• Guidelines for Use of Control-of-Flow Structures
Using Expressions, Variables and Intrinsic Functions
• Naming Rules
• Understand Expressions and Statements
• Declare Variables
• Understand Data Types
• Determine the Value of Variables
• Work with Variable Scope
• Use Built-in VBA Functions
• Understand Constants
• Use Built-in VBA Constants
• Use Message Boxes
• Control the Answer to a Message Box
• Use Input Boxes
• Declaring and Using Object Variables
Working with Forms and Controls
• Understanding User Forms
• Using the Toolbox
• Working with a Form’s Properties, Methods, and Events
• Working with Form and Control Properties, Methods and Event
• Working with Form Controls
• Setting the Tab Order
• Populating a Control
• Adding Code to Controls
Debugging and Handling Errors Error
• Understanding Errors
• Using Debugging Tools
• Setting Breakpoints and Using Break Mode
• Stepping Through Code
• Trapping Errors with the On Error Statement
• Understanding the Err Object
• Working with Inline Error Handling
• Writing an Error-Handling Routine
Introduction to Microsoft Visual Basic -