Excel VBA Level 3
Course
Inhouse
Description
-
Type
Course
-
Methodology
Inhouse
-
Duration
1 Day
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
Important information
Government funding available
About this course
Must be confident or at least have
had sufficient exposure to the concepts covered in Levels 1 and
2.
Reviews
Course programme
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
PREREQUISITES
Must be confident or at least have had sufficient exposure to the concepts covered in Levels 1 and 2.
Revision of Level 2
Speeding up your macros
-
Turning off screen updating
-
Using the status bar to tell the user about your progress
-
Turning off automatic calculation
-
Turning off Alert Messages
-
Simplifying Object References
-
Declaring your variable types
-
Using the with-end with structure
-
Showing and hiding
-
Designing
-
Using option buttons
-
Using check boxes
-
Using multi pages
-
Using other controls
-
Showing / hiding options
-
Adding pictures
-
Ref Edit (so a user can select a range on a sheet)
-
Using a spin button
-
Setting the tab order
-
Adding OK and Cancel buttons
-
Controlling data entered into a form
-
Understanding Events
-
Assigning selections to variables
-
Unloading
-
Using a form as a progress indicator
-
Using the status bar as a Progress Indicator
-
Password protecting your VBA code
-
Manually
-
Adding in useful built-in buttons
-
Adding buttons for macros
-
Customising the button
-
Attaching a toolbar to a workbook
-
Adding in useful built-in buttons
-
Using VBA
-
Why?
-
Creating / deleting a toolbar
-
Showing the toolbar
-
Placing the toolbar
-
Adding Buttons
-
Customising the buttons
-
Resetting all in-built toolbars
-
Preventing any design changes to your toolbar
-
Why?
-
Creating / deleting a menu
-
Placing the menu
-
Adding Buttons
-
Customising the buttons
-
Resetting in-built menu
-
Adding / Deleting menu items to a shortcut menu
-
Disabling a shortcut menu
-
Resetting a shortcut menu
Excel VBA Level 3