Advanced
UserForm List Boxes
Displaying Unique Items
Using a Variable Range Source
List Boxes with Changing
Contents
Multiple Column List Boxes
List Boxes to Select
Rows/Columns/Sheets
Creating
Wizards
Using Multiple UserForms
Using 1 UserForm and
MultiPage Control
Advanced
UserForms
Modeless Dialog Boxes
Using Labels to Display
Formula Results
Examining
a Text Utility
Seeing how Dialog Box can be
made that will:
Change text case
Add text
Remove Text
Remove Spaces
Using
Excel Events
Sequence of Events
Workbook Events
(Activate/Deactivate, BeforeClose, BeforePrint, BeforeSave, NewSheet, Open,
SheetActivate)
Worksheet Events
(BeforeRightClick, Change, SelectionChange)
UserForm Events
Application Events
Timed Events
Disabling events
|
Working
with Charts
Activating & Deleting
Chart Formatting
Converting Embedded Chart to
Chart Sheet and Vice-Versa
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
Customizing Toolbars & Menus with VBA (Excel 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
Working
with Other Applications
Running Simple Applications –
Character Map, Calculator
Interacting with Microsoft
Word
Developing an Add-In
Testing Your Application
Protecting Your Add-In
Snooping Around a Protected
Add-In
|
|
