Close a dialog Sheet

Daniel Cremin · Mar 4th, 2002, 11:48 PM

Hi ppl i just need the code to close down a running old-style dialog sheet - .hide only makes it not active on screen, i need a way to close it down. Thanks

Bruno · Mar 5th, 2002, 01:51 AM

Try this :

Unload YourUserForm
or
Unload YourDialogSheet
_________________

Bruno

[ This Message was edited by: Bruno on 2002-03-05 00:52 ]

Daniel Cremin · Mar 5th, 2002, 02:34 AM

thanks for the tip, I actually know how to create and run modern dialog forms, the only prob is its a pre USERFORM (excel 97) type of Dialog Sheet that im making at the moment (you know the one where you can build it in Excel).
Ne one know the code to close it.

Daniel Cremin · Mar 5th, 2002, 08:20 AM

can any one help me out with this?

[ This Message was edited by: Daniel Cremin on 2002-03-05 08:43 ]

Daniel Cremin · Mar 5th, 2002, 08:37 AM

Please Please Please Help !!! Ive forgotten this line of code and no books contain it these days.

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

please help if you can

Daniel Cremin · Mar 6th, 2002, 02:54 AM

come on someone knows the answer!!!!!!!!!

Bruno · Mar 7th, 2002, 12:25 AM

Hi Daniel
I don't know why the dialoogsheet is still there after hitting the OK button and .hide it...
Maybe you have to force a display update with : Do Events

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

Mar 4th, 2002, 11:48 PM	#1
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	Hi ppl i just need the code to close down a running old-style dialog sheet - .hide only makes it not active on screen, i need a way to close it down. Thanks

Mar 5th, 2002, 02:34 AM	#3
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	thanks for the tip, I actually know how to create and run modern dialog forms, the only prob is its a pre USERFORM (excel 97) type of Dialog Sheet that im making at the moment (you know the one where you can build it in Excel). Ne one know the code to close it.

Mar 5th, 2002, 08:20 AM	#4
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	can any one help me out with this? [ This Message was edited by: Daniel Cremin on 2002-03-05 08:43 ]

Mar 5th, 2002, 08:37 AM	#5
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	Please Please Please Help !!! Ive forgotten this line of code and no books contain it these days.

Mar 5th, 2002, 09:44 AM	#6
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	please help if you can

Mar 6th, 2002, 02:54 AM	#7
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	come on someone knows the answer!!!!!!!!!

Mar 7th, 2002, 12:25 AM	#8
Bruno Board Regular Join Date: Feb 2002 Posts: 468	Hi Daniel I don't know why the dialoogsheet is still there after hitting the OK button and .hide it... Maybe you have to force a display update with : Do Events