If TargetAddress vs If TextBoxes(userform controls)

[Flexcel22]

Hi Everyone,

I remembered working with If TargetAddress which works with pointers. It really amazing using it to do manipulating since all you do is just use a tab key or arrows.

I wondered if this can be applied in a userform.

My case:

I had a userform with many textboxes of around 60. All with the same size and font. There's one textbox which is 6 times bigger in size and font than the remaning textboxes.
I wanted to use the bigger textbox to keep displaying an active smaller textbox content. In this way when I press tab key on my keyboard to jump from textboxt to textbox, the bigger one will automatically display the content of whichever is selected or activated.

Any idea?

 

[My Aswer Is This]

Thanks for that explanation.

@Flexcel22
Thanks for the feedback and glad I could help.

@My Answer Is This

The script iterates all the textboxes in the userform and retrieves the CurX Property of each TextBox. If the TextBox doesn't currently have the focus, it generates an error. If the textbox has the focus no error is generated... I take advantage of this to know which textbox is currently active.. Once I find the active textbox that has the focus, I just pass its value to the main textbox and exit the iteration.