User Guide

646
Chapter 46
Adding a Desc
riptiontoaScript
You can add a
description to be displayed in the Run Script and Use Starter Script
dialog boxes. Just add a comment on the first line of the script that starts with
Begin
Description
,followedbythedesiredcomment(one or more lines), followed
by End Descr
iption
. For example:
'Begin Desc
ription
'This s cript changes "Sig." to "p=" in the column labels of any pivot table.
'Requirement: The Pivot Table that you want to change must be selected.
'End Descri
ption
The description must be formatted as a comment (each line beginning with an
apostrophe).
Scripting Custom Dialog Boxes
There are two steps to implementing a custom dialog box: first create the dialog box
using the UserDialog Editor, and then create a dialog monitor function (DialogFunc)
that monit
ors the dialog box and defines its behavior.
The dialog box itself is defined by a
Begin Dialog...End Dialog block.
You do not need to type this code directly-the UserDialog Editor provides an easy,
graphical
way to define the dialog box.
Figure 46-16
Creating a dialog box in the U serDialog Editor