+ Reply to Thread
Results 1 to 4 of 4

Userform msgbox option to return to parent form

Hybrid View

  1. #1
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Userform msgbox option to return to parent form

    Hello Hammer_757,

    This change will do what you want...
            'If user did not selcet any employees, remind them and give option to correct or exit
            If atndCnt < 1 Then
                
                Dim varAnswer As String
                varAnswer = MsgBox("You did not select any attendees. No updates were made. Would you like to select attendees?", _
                vbYesNo, "Warning")
                If varAnswer = vbNo Then
                    'Exit Sub
                    cbn_Close_Form_Click
                    
                    Else
                    'go back to the form
                    lstAttendees.SetFocus
                    lstAttendees.TopIndex = 0
                    Exit Sub
                End If
                
            End If
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  2. #2
    Forum Contributor
    Join Date
    03-21-2004
    Location
    Norwich, CT USA
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: Userform msgbox option to return to parent form

    thanks Leith!
    that worked perfect

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1