ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do I create a dialog box in Excel 2003 (https://www.excelbanter.com/excel-programming/381933-how-do-i-create-dialog-box-excel-2003-a.html)

c1802362

how do I create a dialog box in Excel 2003
 
in early version of excel, you insert a new dialog box worksheet with the
Insert/Macro/Dialog command. In excel 2003 what is the comparable command?

Jim Rech

how do I create a dialog box in Excel 2003
 
You can still insert dialogsheets in a workbook (Right click a worksheet tab
and pick Insert). But creating a userform in the VBE (Insert, Userform) is
the way to go since Excel 97.

--
Jim
"c1802362" wrote in message
...
| in early version of excel, you insert a new dialog box worksheet with the
| Insert/Macro/Dialog command. In excel 2003 what is the comparable command?



c1802362

how do I create a dialog box in Excel 2003
 
Thanks for the advice - it worked perfectly on my PC (at work)

However, at home I have a Mac - any suggestions to get to the dialog box
form on the Mac?

"Jim Rech" wrote:

You can still insert dialogsheets in a workbook (Right click a worksheet tab
and pick Insert). But creating a userform in the VBE (Insert, Userform) is
the way to go since Excel 97.

--
Jim
"c1802362" wrote in message
...
| in early version of excel, you insert a new dialog box worksheet with the
| Insert/Macro/Dialog command. In excel 2003 what is the comparable command?





All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com