In Chapter 3, we looked at VBA b uilt-in Help facilities. However, most users of Excel - or of any other Office application - will have had some experience with the Office Assistant. When clicked, this will deliver Help known as Balloon Help - so-called because of the way in which it is displayed (Figure 10.13). It is possible to customise the Help delivered by the balloon object, so that we can create context-sensitive Help, which could be of significant benefit to a user who needs support with some Excel application. This is one of several objects that Microsoft makes available to each of its Office applications. The Assistant displays inside the balloon a heading followed by a list of menu options and some buttons at the bottom.
The illustration shows the standard Excel/VBA Help, but y ou can customise this to application specific Help. For example, suppose it was necessary to include balloon Help to the user of the SALESMAN workbook. It could be invoked by using a macro button called Help. This button could be linked to a macro called Assist. We can see from Figure 10.14 that a balloon can contain a plethora of items - such as headings, buttons and text. They can also contain check boxes, radio buttons, and so on.
To maintain weekly sal to calculate sales to da foi each representative i^trhi
Each cell value in this y Total by the Bonus Rate th 3 ale s c olumn for the b e ginnin g of e ach
Ith v See more,
Each cell in this range
This cell value is increi
Sales To Dale illy Total
Microsoft EKcei ■ SALESMAN
-Create a macro e Stop a macro f^ft ofMojlth ¡tech cell value in this
End of Month Si
M I Sheet 1 I weeklvsdes Í
i 5umnnarv /
Figure 10.13 The Office Assistant delivering balloon Help
Was this article helpful?