Chapter 24: Providing Help for Your Applications


Providing user help for your applications

Using only the components supplied with Excel to provide help

Displaying help files created with the HTML Help system

Associating a help file with your application

Displaying HTML Help in other ways

Help for Your Excel Applications

If you develop a nontrivial application in Excel, you may want to consider building in some sort of help for end users. Doing so makes the users feel more comfortable with the application and could eliminate many of those time-wasting phone calls from users with basic questions. Another advantage is that help is always available: That is, the instructions can't be misplaced or buried under a pile of books.

You can provide help for your Excel applications in a number of ways, ranging from simple to complex. The method that you choose depends on your application's scope and complexity and how much effort you're willing to put into this phase of development. Some applications might require only a brief set of instructions on how to start them. Others may benefit from a full-blown, searchable Help system. Most often, applications need something in between.

This chapter classifies user help into two categories:

Unofficial Help system: This method of displaying help uses standard Excel components (such as a UserForm).

Official Help system: This Help system uses a compiled CHM file produced by Microsoft's HTML Help Workshop.

Get Excel® 2010 Power Programming with VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.