Mac Excel VBA Macros

Mouse Training
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' To develop automated procedures in Excel using the Visual Basic for Applications language
What is a Macro?


Concept and discussion


The Visual Basic Interface

The Project Window
Code Window
Properties Window
Navigating between Excel and the VB Editor

Recorded Macros

Record New Macro
Assigning a keyboard short cut
Saving with the file


Methods of Executing

Menu
Visual Basic Toolbar
Keyboard Shortcut
Custom Toolbar Button
Custom Menu Item
Button
Alt [F8]
Forms Toolbar


Editing the Code

Using the Visual Basic Editor
Structure of a sub routine
Describe the colour scheme of Key Words
Navigation in a Module
Editing in a module
Use of Function Keys
Reassign keyboard shortcut
Run subroutines together


Checking For Errors

Debugging
Step Mode
Immediate Window
Object Browser
Toggle Breakpoint
Help system


Types of Recording

Relative
Absolute


Portability

Personal Macro Workbook
This Work Book
New Workbook
Add-ins


Creating New Functions

Uses
Function Keyword
Use of Arguments
Variables
Constants

Control Structures
IF
Nested IF
AND OR NOT
SELECT CASE
Inbuilt Functions
Distribution
Watch Pane
Step through Functions using the immediate Window


VBA Language Rules
Theory of Object
Properties and Methods
Active Objects
Object Model Hierarchy
Inheritance


Spreadsheet Form Controls

Combo box
Spinner control
Scroll bar
Option button
Check Box control


Interactive Macros

Msgbox
Conditional Message Box
Inputbox

Creating Interactive Forms

Form Controls
User forms
Using the Properties Window
Combo box
Radio Buttons
Group box
Check box
Built in Dialog Boxes
Creating Custom Menus
Creating Custom Toolbars


Event Procedures
What are Event Procedures?
On Open
Before Close
On Activate
On Deactivate
On Key
On Time


Security
Protecting/locking code for view/edit
Digital Signatures


Customizing the VB Editor


Dockable Windows
Format Editor


...''

Phone:+44 (0) 20 7920 9500

School Address:

7th Floor Crystal Gate
28-30 Worship Street
London
EC2A 2AH
United Kindom


Jobs & Resumes: London
Houses & Roommates: London

MS Visio 2007
MS Project 2007 Introduction
MS Project 2007 Advanced
MS Outlook 2007
FrontPage Introduction
Microsoft FrontPage Advanced
MS Publisher
Mac Excel Introduction
Mac Excel Intermediate
Mac Excel Advanced
Mac VBA Macros
Mac Word Advanced
Mac Word Intermediate
Mac Word Introduction
Mac PowerPoint Advanced
Mac PowerPoint Introduction
Mac Entourage
Adobe Flash Intermediate
Adobe Flash Introduction

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.