Check for changes

[Av8tordude]

I have a userform with a combination of textboxes and combo boxes. If I make changes to any of them, can someone assist with a code that will check if any changes have been made?

Thank you kindly.

 

[steve the fish]

All userforms ive ever made have some sort of change procedures within the userform module. You use things such as:

Private Sub TextBox1_Change()
'add some code to respond to the change
End Sub

 

[Av8tordude]

Thank you for replying. I understand the change event and how it works, however, I was wondering Is it possible to write just one subroutine that detects a change in any of the controls of the form. My goal is if anything has been change, display message box stating "Changes made".

 

[steve the fish]

Forgive me for wondering but wouldnt a user know if they have made a change to a userform without being told?

 

[Jaafar Tribak]

Thank you for replying. I understand the change event and how it works, however, I was wondering Is it possible to write just one subroutine that detects a change in any of the controls of the form. My goal is if anything has been change, display message box stating "Changes made".

Do a search in this board for TextBox and Calss Module