Activating a dialog frame (Run Dialog)

  • Thread starter Thread starter VILLABILLA
  • Start date Start date
V

VILLABILLA

Thank you very much for the explanation, I now managed to create
dialog sheet with on it a dialog frame including a combo box on it.
would like a button on one of my normal work sheets to activate th
dialog frame(Run Dialog). How do I do that?

Thanks in advance
 
Sorry, this had to be a reply on an earlier post from yesterday but
made a mistake and putted it as new threat. Well it is a threat anywa
so help would still be very appreciated,

With some help I managed to create a dialog sheet, there I made
dialog frame with a combo box on it (using the Forms toolbar).

How do I run the Dialog? I would like the Dialog to run by pressing
button or autoshape on of my worksheets....

Thanks
 
A dialog ? Good old Dialogsheets ? Nice.

Open the VB editos (Alt F11 or similar). Menu Insert > Module. Paste this
into the blank module:

Sub ShowDialog()
DialogSheets(1).Show
End Sub

Return to Excel and a spreadsheet. Rightclick one of your shapes, choose
"assign Macro" and choose "ShowDialog". And that should be it.
 
Thanks very much, it works just fine like this!

Out of interest: What would be the 'new' way of using dialogs then? Is
that a easier/better way?

Please update me...
 
Since Excel 97 there's Userforms, and simoultaneously Dialogs was hidden
from the object model. Lots of people will tell you that Userforms replaced
DialogSheets. Not true, dialogs work fine and can do a few graphical things
that forms can't. Userforms' advantage is the huge lot of events built into
them and their controls, sothat macrocode runs when mouse is moved, when
distinct keys are pressed, when lists are clicked, ...

See
http://members.optusnet.com.au/anandasim/xlforms_&_controls.htm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcel9/html/xlxl97mig.asp

http://www.design-drawing.com/visio/kgmsforms.htm
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
http://www.microsoft.com/OfficeDev/Articles/OPG/012/012.htm

But as stated, dialogs are fine. If they work for you then change nothing. I
still build them for spesific tasks -but I may be the only one around here.
 
Back
Top