Determine Which TextBox has... 1

[Yogi39]

I have a user form with 6 textboxes.
How can I code to see which box has focus or is active ?

 

[fatherofthree]

What are you wanting to do once you have determine if a particular cell is active or GotFocus?

 

[TonyJollans]

Hi Yogi39,

Use Me.ActiveControl

Enjoy,
Tony

 

[Yogi39]

me.activecontrol result is the conmtent.
I would like the control name if possible ?

 

[Yogi39]

cool thanks....
Use Me.ActiveControl.name

 

[TonyJollans]

Hi Yogi39,

ActiveControl is an object. You can access all of its Properties, so for its name use Me.ActiveControl.Name

Enjoy,
Tony