Dialogue Box - how do I get it to open...

[mrowe]

When I've created a custom dialog box, how do I get it to load on screen when the worksheet is opened or option is selected from a custom menue?
Thanks

 

[Daniel Cremin]

which type of dialog box - pre excel 97 era ones (the ones u insert in excel) or those darned vba based ones. If its the first then its
DialogSheets("Name").Show

if its the latter then it involves a Load statement, cant remember the exact code as i hardly ever use them.

 

[mrowe]

I'm using Excel 97, so I guess it's the load statement - if you or anyone else could help that would be great!

Cheers
Matt

 

[Daniel Cremin]

how did you build it - in the vba editor or by right-clicking the sheet tab and inserting a dialog sheet? The original (second) option is considered outmoded but is in my opinion much better.
This message was edited by Daniel Cremin on 2002-03-05 07:40

 

[mrowe]

I tried the VBA editor - I'm new to dialogue boxes, so will try anything.
If I use the right hand click option do I just need to include the code above somewhere?

 

[Daniel Cremin]

Ok heres what i would do - go to excel's main window and right click -insert a dialog sheet and then for the Ok and cancel buttons right click them and enter your code in a macro. Create the text boxes and other controls you want to use - colour the sheet in any colour you want via rectangles inserted and sent to the back on the sheet. and then create a macro to trigger the form containing the code DialogSheets("whatever its called").Show

 

[mrowe]

Thanks for your help.

 

[Daniel Cremin]

your welcome