Userform Cancel Button - Click No

[Pacman52]

Hi for some reason I just can't code a cancel button's 'No' response to simply return to the userform the user was on when the button was clicked.

When the 'Yes' response is clicked the form closes and loads the Main form as it is meant to but if I click No then the current form also closes. The code below is what I started with but I've tried various ways to just go back to the original form.

Anyone got any suggestions please?

Thanks Paul

Private Sub cmbCancel_Click()

        MsgBox "Are you sure you want to cancel this record?" & vbCrLf & _
        "If you select yes, you will lose all the information entered.", vbExclamation + vbYesNo, "Cancel Entry"
            
        Unload Me
        MainList.Show

End Sub

 

[dmt32]

Your code is not testing the return value of the msgbox function

Try this update & see if resolves

Private Sub cmbCancel_Click()

        If MsgBox("Are you sure you want to cancel this record?" & vbCrLf & _
        "If you select yes, you will lose all the information entered.", vbExclamation + vbYesNo, "Cancel Entry") = vbYes Then
            
        Unload Me
        MainList.Show
       End If

End Sub

You can read more on the Msgbox function in VBA helpfile

Dave

 

[Pacman52]

Thanks so much for the reply and the link on msgbox's. I just assumed if the No option was clicked nothing would happen but thats just my inexperience showing. I'll have a read through the link showed as it will help me learn more but the code edit you supplied works perfectly.

Thanks again Paul

 

[dmt32]

most welcome - your appreciate feedback

Dave