VBA - textbox group event on tab?

[ildenizen]

I have a userform with a grid of textbox entries (these are gouped and am using a class so I can trigger an event for any of them).
Each row has a label, each column has a label as well.
The grid is fairly large, and often as I am selecting a textbox to enter data, I want to quickly "see" the row/column labels corresponding to the textbox, to be sure I am not entering information in the incorrect row/column by mistake.

The desired behavior is to change the row and column labels (highlight, change backgound, etc) when I have selected a textbox.
I can get to the textbox either by mouse clicking, or by tabbing into it.

I can use the mousedown event to capture the event when I click on any textbox, where I can then detemine the textbox and make the row/column label format chantes. So far so good.
However, I have not been able to find an event or trigger that would occur when I have tabbed into the textbox and before I have made any text changes.

Any ideas if this is possibe?
Thanks in advance.

 

[bensonsearch]

Hi,
the enter event will do. this happens when you tab/click into the field.