Which Control has the Focus??

[Ken Soenen]

Is there a way (Software-wise) you can determine which control on a form
currently has the Focus??

Thanks,
ken

 

[Dave Peterson]

Take a look at ActiveControl in VBA's help.

I put a bunch of controls on a userform, then used this code to display the
activecontrol's name:

Option Explicit
Private Sub CommandButton1_Click()
MsgBox Me.ActiveControl.Name
End Sub
Private Sub UserForm_Initialize()
With Me.CommandButton1
.TakeFocusOnClick = False
End With
End Sub

 

[Ken Soenen]

Thanks Dave. This is exactly what I need. In the future I have to pay more
attention to the PROPERTY/METHOD list that drops down after typing the
period. It shows the ActiveControl property there but it doesn't show it in
the Property Window(where I normally look).

ken