Learning more about builtin dialog boxes

You can get a list of all the dialog box constants either by consulting the Help system or by using the Object Browser. Follow these steps to display the members of the Dialogs collection in the Object Browser:

1. In a VBA module, press F2 to bring up the Object Browser.

2. In the Object Browser dialog box, select Excel from the top list.

3. Type xlDialog in the second list.

4. Click the binoculars (Search) button.

Attempting to display a built-in dialog box in an incorrect context will result in an error. For example, if you select a series in a chart and then attempt to display the xlDialogFontProperties dialog box, you'll get an error message because that dialog box is not appropriate for that selection.

0 0

Post a comment