Try this :
Unload YourUserForm
or
Unload YourDialogSheet
_________________
Bruno
[ This Message was edited by: Bruno on 2002-03-05 00:52 ]
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
Try this :
Unload YourUserForm
or
Unload YourDialogSheet
_________________
Bruno
[ This Message was edited by: Bruno on 2002-03-05 00:52 ]
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.
can any one help me out with this?
[ This Message was edited by: Daniel Cremin on 2002-03-05 08:43 ]
Please Please Please Help !!! Ive forgotten this line of code and no books contain it these days.
please help if you can
come on someone knows the answer!!!!!!!!!
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
Like this thread? Share it with others