Excel VBA
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
On completion of this course the user will be able to design, write and debug Excel Visual Basic macros, create a dialog box and suitable control structures, and create custom Excel functions. Suitable for: This 2-day course is aimed at experienced Excel users, preferably with some awareness or experience of computer programming.
Facilities
Location
Start date
Start date
Reviews
Course programme
This 2-day course is aimed at experienced Excel users, preferably with some awareness or experience of computer programming. On completion of this course the user will be able to design, write and debug Excel Visual Basic macros, create a dialog box and suitable control structures, and create custom Excel functions.All the Open Scheduled VBA courses delivered by PPI Learning are suitable for all delegates no matter what version of Office they are working with in their own company's environment. We have chosen the middle ground as the delivery mechanism; so all VBA course will be delivered using Office 2000. If a specific version of VBA is required, then a private VBA course will need to be arranged with the PPI Learning Sales Executive.Course content
- Recording Macros in Excel
- Saving Macros for use with the Current File or All Excel Files
- Assigning Shortcuts
- Recording With Absolute or Relative References
- Assigning Macros to Buttons or Shapes on a Worksheet
- Assigning Macros to Toolbar Buttons
- Adding Controls to a Worksheet
- Creating Custom Excel Functions
- The Visual Basic Editor
- The Project Explorer
- The Properties Window
- Visual Basic Modules
- Editor Options
- Editor Views
- Editing Visual Basic Code
- Creating Toggle Macros
The Concepts of Object-Oriented Programming
- Visual Basic Syntax
- The Structure of Procedures
- The Declaration Section
- Comments
- Keywords
- Indenting Code
- Navigating Code Using the Keyboard
- Bookmarks
- The Last Position Command
- Getting Assistance from the Editor when Entering Code
Declaring Variables
- Variable Scope
- Variable Type
- Type Conversion Functions
- Constants
- Arrays
Control Structures
- The With Statement
- If Statements
- Select Case
- Do Loop
- For Next Loops
User Interaction
- The MsgBox Statement
- The InputBox Function
- Creating UserForms
Working with Form Controls and the Control Toolbox
- Adding Code to Forms
- Displaying Forms with Module-Based Code
- Pausing Code Execution
- Locating Errors in Code
- Handling Run-Time Errors
- Setting Bookmarks
- Setting Breakpoints
- Tracing the Execution Path Using the Call Stack
- Setting Watches
- Viewing Variable and Array Values in Break Mode
Excel VBA