Excel: xy Coordinates Ignored for Triggered, Movable Dialog

ID: Q84019


The information in this article applies to:


SUMMARY

A floating dialog box that is displayed as a result of a trigger item from another floating dialog box is displayed with its upper-left corner aligned to that of the first dialog box. That is, the x and y coordinates in the second floating dialog box description are ignored.

To work around this problem, change the type of either dialog box to the non-movable variety.


MORE INFORMATION

A movable dialog box is designated by typing a name in the text column (column 6) of the first row of a dialog box definition table. To change a movable dialog box to a fixed dialog box, remove this text.

Under normal circumstances, the placement of a dialog box can be controlled by entering x and y coordinates into the fourth and fifth columns of the first line of the dialog box description table. If these coordinates are left out, the dialog box will be centered on the monitor when it is displayed.

To specify a trigger items, add 100 to the item number in the dialog box definition table.


REFERENCES

"User's Guide 2," version 4.0, pages 272-282
"User's Guide," version 3.0 for the Macintosh, pages 628-636
"Microsoft Excel User's Guide," version 3.0 for Windows, pages 631-640

Additional query words: 3.0 dialogue sticky


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 24, 1999