Close a dialog Sheet
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Close a dialog Sheet

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular Bruno's Avatar
    Join Date
    Feb 2002
    Posts
    480
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this :

    Unload YourUserForm
    or
    Unload YourDialogSheet
    _________________


    Bruno


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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can any one help me out with this?

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

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    please help if you can

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  8. #8
    Board Regular Bruno's Avatar
    Join Date
    Feb 2002
    Posts
    480
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com