Skip to Content
0
Former Member
Aug 11, 2016 at 10:15 AM

Do you want to save Changes ? User Form

132 Views

Hi All,

I need to implement this below option in my User Form.

Do you want to save Changes? Message when User Clicks X(Close Button) in the Form?

Sample Code

Dim iReturnValue As Integer

iReturnValue = SBO_Application.MessageBox("Do you want to continue?", 1, "&Yes!", "&No", "&Cancel")

Select Case iReturnValue

Case 1

<Add Method>

Case 2

oForm = Nothing

SBO_Application = Nothing

ToResetVariables()

Case 3

<Code for (Click "Cancel button message Box)> I do not what code add here.

End Select

Please refer Standard Form for this Cancel Button action.

It's urgent