How to get the active field?

[DeepButi]

I have a Form with several Text fields that go to a common code on TextBoxn_Change. How do I get the field that triggers the event so I can call the common routine with it?

 

[DeepButi]

It does if your controls are on a userform. If they they are on a sheet then there is no such thing as a Change event for FormControls.
So what exactly are you using?

Bingo!! You are right. It works on a Form.

Thanks a lot.

 

[Skyybot]

I have a Form with several Text fields that go to a common code on TextBoxn_Change. How do I get the field that triggers the event so I can call the common routine with it?

Your OP said you were using a Form. That's why I my code was written that way.

 

[DeepButi]

Your OP said you were using a Form. That's why I my code was written that way.

Right. Sorry, my fault.