Who's got focus

**Mats Samson** · 10-19-2011, 01:43 PM

Is it possible to find out which control in the Userform that has Focus?

**tlafferty** · 10-19-2011, 02:14 PM

Please Login or Register  to view this content.

**Mats Samson** · 10-19-2011, 02:18 PM

Sorry, sorry!
I forgot to tell that the controls are on a Multipage and then the only reply by "Me.ActiveControl.Name" will be MultiPage1

**Leith Ross** · 10-19-2011, 02:38 PM

Hello Mats Samson,

Add this function in the Declarations section of the UserForm. You can then call it from anywhere in your code. It returns the control with the focus.

Please Login or Register  to view this content.

**tlafferty** · 10-19-2011, 02:40 PM

try:

Please Login or Register  to view this content.

**Mats Samson** · 10-19-2011, 04:57 PM

Hello!
Leith: I can't get your function to work, (even when exchanging x with SelCtrl)
Thomas: You're getting closer! As the controls are "grouped" in Frames, the reply is Frame415,
eg. the Frame where f.i. the TextBox is located.

**Leith Ross** · 10-19-2011, 05:03 PM

Hello Mats Samson,

Did you copy the code to the top of your UserForm?

Did you call it like below? Remember, the function it is returning the control itself.

Please Login or Register  to view this content.

**Mats Samson** · 10-19-2011, 05:48 PM

Hello Leith,
thanks, it works OK!
I used MsgBox GetActiveControl (), not .....Name
Cheers
Mats

**Leith Ross** · 10-19-2011, 05:50 PM

Hell Mats,

I am happy it something easy to fix. Thanks for letting me know what you did.

**Mats Samson** · 10-20-2011, 04:37 AM

Originally Posted by Leith Ross

Hell Mats,

I am happy it something easy to fix. Thanks for letting me know what you did.

Leith,
is it possible to include named range(s) connected to the controls (text- & comboboxes) and take action in the connected cell depending on which control is in focus? The RowSource connection is made via the code, not in the control itself. (There are also a variable connected to each control, but as I understand variables cannot be referenced via concatenation)
Regards
Mats