PDA

View Full Version : Solved: Run a dialog using Macro



dansam
03-10-2007, 12:40 AM
Hi, :hi:
On my workbook I have two items:
(1) Sheet1
(2) Dialog 1

I can run the dialog using the ?run dialog? button from the ?FORMS? toolbar. I want to know that how to run that dialog using a macro?? :think: (Like to show user form we use ?userform1.show?)

Regards,
Dan

Marcster
03-10-2007, 12:51 AM
Hi Dansam,

Try this:

DialogSheets("Dialog1").Show


Marcster.

dansam
03-10-2007, 12:54 AM
Hi Marcster,
It just got worked fine.
Thank you very much for kind help.

DAN

dansam
03-10-2007, 12:56 AM
And what to do if I want to hide that dialog ??
dan

Norie
03-10-2007, 09:04 AM
Dan

A dialog sheet?:bug:

They date back to Excel 95 or thereabouts.

I'm pretty sure they've been replaced by userforms.

dansam
03-10-2007, 09:10 AM
Oh!! :wot
I didn’t know the matter!
I am just trying to learn that what kind of thing is a dialog sheet !!
But … Thanks for suggestion :clap:


Regards,
Dan