tracking changes and prompt user

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
:)

Code:

---

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

---