Help needed On Change Event?????

[Shallo9]

Hello All,

Does On_Change event triggers only when the data is changed physically or does it triggers even when it populates from some where else (Like calculated field) ?

Basically, I got a text box "A" which gets the value depending on the value of another text box "B" or "C". I want to run a code whenever the data changes in "A"?

I've tried placing the code in after update of "B" & "C" (Works fine) but dont want to place the code twice so thinkin' of tweekin the code in "A" as this changes every time there is an update in "B" or "C".

Many Thanks

 

[vbaInet]

Anything that affects the Text property of the textbox will cause the Change event to fire. In general, typing into the control affects the Text property which will in turn fire the Change event. If you want the Change event to be fired in code you need to change the Text property not the Value property.

And before you can do this the control must have focus. You can now see that what you're trying to do is fruitless or not logical.