I right-clicked on the tabs at the bottom of the worksheet to create a new
tab. One of the choices it offered me was "MS Excel 5.0 Dialog." When I
selected this, it came up with a worksheet that looks like a visual basic
work area where I can create whatever I want. It would be great if I could
use this function to create a checklist. I run a large number of projects at
one time. If I could click on the project name, and have this checklist come
up, it would be cool. I can create the checklist, then have it show up by
clicking the "Run Dialogue" button in the tool bar, but I don't know how to
have Excel run the dialog automatically when the tab is selected. Also don't
know how to go to individual versions of this checklist from another cell.
There is ver little help that I can find on the "dialog" subject.

For the most part, the dialogs stuff has gone away--it's still supported by
newer versions of excel and there are a few people who use them because of the
way you can make them look (Hi, Harald!), but most users are now using Userforms
(xl97 and later).

I think your time might better be spent learning about userforms.

If you want to, here's a link to Debra Dalgleish's site:
http://www.contextures.com/xlUserForm01.html



Jerryclick wrote:

I right-clicked on the tabs at the bottom of the worksheet to create a new
tab. One of the choices it offered me was "MS Excel 5.0 Dialog." When I
selected this, it came up with a worksheet that looks like a visual basic
work area where I can create whatever I want. It would be great if I could
use this function to create a checklist. I run a large number of projects at
one time. If I could click on the project name, and have this checklist come
up, it would be cool. I can create the checklist, then have it show up by
clicking the "Run Dialogue" button in the tool bar, but I don't know how to
have Excel run the dialog automatically when the tab is selected. Also don't
know how to go to individual versions of this checklist from another cell.
There is ver little help that I can find on the "dialog" subject.

--

Dave Peterson