tracking changes and prompt user

[princ_wns]

hi all,

i have an some data on a sheet and there is a combo box on selection change in combo box i want to give a msg to the user that he has made some change do he want to save changes or not, if he made any change in the range i have set.



thanks in advance

[Excel Fox]

Private Sub ComboBox1_Change()

    If vbYes = MsgBox("You have made a change. Do you want to save it?", vbYesNo, "Save Change?") Then
        ThisWorkbook.Save
    End If
    
End Sub