Test For Changed Text

[sirmilt]

I have an application that triggers a string of calculations and other events when the user leaves a text box. What I would like to do is test to see if the text in the box has been changed and if not exit the sub and avoid the events that would normally follow.

A simple comparison to nothing is not a valid comparison because if the user deletes a previously entered value I need to go through all of the events and calculations.

Is there a simple and effective way of doing this?

 

[.paul.]

use a form level string variable to hold the previous text

 

[JuggaloBrotha]

Use a Boolean at the form level, then in the TextChanged event set your boolean to True and after the calculations set the boolean to False