how do I create a dialog box in Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

c1802362 - 25 Jan 2007 20:02 GMT

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?

Reply to this Message

Jim Rech - 25 Jan 2007 20:08 GMT

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.

Signature

Jim

| 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?

Reply to this Message

c1802362 - 27 Jan 2007 00:18 GMT

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?

> 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.
>
> | 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?

Reply to this Message