48 Nifty Things You Can Do With
Excel
Need to do something quickly to get
Microsoft Excel to conform to your perticular needs? Want to make
Excel handle some repetive task. We have written a simple conciese
book that provides easy to use information to do this. You do not
have to be a computer science major to put to use what the book
offers.
- Getting Started with VBA
- The Workbook Object
- What VBA can do with Excel
- A Little Software Background
- Security
- Finding Files
- The Excel VBA Project
Environment
- Displaying the VBA Toolbar
- Toolbox Controls
- Macros – An Easy Way to Start
Programming
- Declaring Variables (Module
1)
- Navigating around a Workbook
- Color Coding
- Formatting
- Making Decisions
- Performing an Action
Repeatedly
- Finding Things with VBA
- Creating Forms and Message
Blocks
- Rooting out Problems
- Message Box
- Error Handling
- Troubleshooting Problems with
Code
- THE 40 Things
- Managing the Workbook (Module
2)
- List Worksheets
- Automatically Create a New
Worksheet
- Automatically Hide and Unhide
Worksheets
- Trigger Actions When the Worksheet is
Opened or Closed
- Make Things Happen at
Startup
- Create Workbook Toolbars
- Set Which Toolbars are
Displayed
- Restore Toolbar List to Normal When
Closing
- Program Special-key Use
- Determine the Number of Rows
- Determine the Current Row
- Automatically Create
Comments
- Creating Shapes/Basic Drawing (Module
3)
- Create a Block
- Create a Triangle
- Create a Horizontal Line
- Create a Vertical Line
- Create a Special Character
- Create Racks
- Clear Area Selected
- Calculations--Finance (Module
4)
- Calculate an Annuity
- Calculate the Future Worth of a Sum of
Money
- Calculate the Present Worth of a Future
Sum of Money
- Calculate a Loan Payment
- Timelines/Project Planning (Module
5)
- Generate a Timeline for a
Project
- List Project Steps
- Save Project Dates
- Recall Project Dates
- Generate a Gantt Chart
Timeline
- 2D-Color Drawing/Generate a Floor Plan
(Module 6)
- Ready the Floor Plan
- Color-code Rooms
- Create a Facility (or Home)
Layout
- Create a Room
- Add Objects to the Room
- ADD GRAPHIC OF THE RESULTS OF THE
CODE
- Sound and Video (PIZZAZZz
Worksheet)
- Play a Wave File
- Speak, Text to Voice
- Play a MIDI File
- Create a MIDI File
- Display a Picture
- Play a Video File
- Conclusion