Working with Macros and Visual Basic for Applications

Excel incorporates Visual Basic for Applications, a programming language which greatly enhances the power of Excel.

This section allows you to create a range of objects such as Dialog Boxes and List Boxes which will turn your spreadsheets into a professional looking products.

Topics Include:

Working with Macros
Creating a simple Macro
The Macro Sheet
Visual Basic For Applications
Learning Visual Basic For Applications
Assigning Macros to Buttons
Labeling Buttons
Adding a Scroll Bar
Come in Spinner !
List Boxes
Message Boxes
Pressing Buttons and Keeping Control
Adding a List Box to a Dialog Sheet
Running the User Form via a Macro
A La Carte Menus
Cleaning up Your Act
Jump Starting Your Application

---