Consulting

Results 1 to 3 of 3

Thread: Solved: Why doesn't the dialog disappear

  1. #1
    VBAX Tutor
    Joined
    Oct 2007
    Posts
    210
    Location

    Solved: Why doesn't the dialog disappear

    This is the code for the close button on my dialog box called SortDialog
    When this dialog box is closed the one under it is focused (like I want), but SortDialog is still behind it.

    [VBA]Private Sub CloseButton_Click()
    Application.ScreenUpdating = True
    SortDialog.Hide
    Unload SortDialog
    Application.ScreenUpdating = False
    End Sub
    [/VBA]
    "The amount of stupid people in the world is God's way of punishing the smart people" - protean_being

  2. #2
    Have you tried just doing this
    [VBA]
    Private Sub CloseButton_Click()
    Unload Me
    End Sub
    [/VBA]
    Phil J.

  3. #3
    VBAX Tutor
    Joined
    Oct 2007
    Posts
    210
    Location
    Thanks. That worked
    "The amount of stupid people in the world is God's way of punishing the smart people" - protean_being

Posting Permissions

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