Advanced UserForms &
Dialog Boxes
Advanced List Boxes
Creating New List Box from Selected
Items in Another
Move
Items
List
Boxes to Select Rows/Columns/Sheets
Developing Text
Utilities
Creating a Dialog Box that will:
Change text case
Add
text
Remove Text
Remove Spaces
Working with Charts
Activating & Deleting
Chart
Formatting
Looping
Through All Charts
Changing Chart Type Based on Selected Cell
Displaying in UserForms
Working with
Pivot Tables
Creating a Pivot Table with VBA
Modifying a Pivot Table
Creating Multiple Pivot Tables
|
Using Excel Events
Workbook Events (Activate/Deactivate, BeforeClose, BeforePrint,
BeforeSave, NewSheet, Open, SheetActivate)
Worksheet Events (BeforeRightClick, Change, SelectionChange)
Application Events
Timed
Events
Disabling events
Working with Other
Applications
Running
Simple Applications – Character Map, Calculator
Interacting with Microsoft Word
Customizing Toolbars
& Menus with VBA (Excel 97 to 2003)
Showing/Hiding
Create and Customize Command Bars
with VBA
Making
Toolbars Context-Sensitive
Customizing Menus with VBA
Adding/Deleting Menu Items
Working
with Shortcut Menus
Creating Wizards
Using
the MultiPage Control to design Wizards
|