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

mrowe · Mar 5th, 2002, 08:32 AM

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 · Mar 5th, 2002, 08:36 AM

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 · Mar 5th, 2002, 08:38 AM

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 · Mar 5th, 2002, 08:39 AM

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 · Mar 5th, 2002, 08:43 AM

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 · Mar 5th, 2002, 08:47 AM

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 · Mar 5th, 2002, 08:54 AM

Thanks for your help.

Daniel Cremin · Mar 5th, 2002, 09:00 AM

your welcome

Mar 5th, 2002, 09:00 AM	#8
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	your welcome __________________ The dialog-sheet (Pre 97) obsessed lad who loves to get around probs like not being able to change background colours. Crap otherwise in Excel!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 08:32 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	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

Mar 5th, 2002, 08:36 AM	#2
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	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.

Mar 5th, 2002, 08:38 AM	#3
mrowe Board Regular Join Date: Feb 2002 Posts: 232	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

Mar 5th, 2002, 08:39 AM	#4
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	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 ]

Mar 5th, 2002, 08:43 AM	#5
mrowe Board Regular Join Date: Feb 2002 Posts: 232	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?

Mar 5th, 2002, 08:47 AM	#6
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	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

Mar 5th, 2002, 08:54 AM	#7
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Thanks for your help.