Can I determine the name of current control in VBA

[MLH]

Looking to use something to determine
name of control with focus in A97 app.

Is there something like Screen.currentcontrol.Name?

[jbguernsey]

MLH

Screen.ActiveControl.Name

HTH

Jeff

MLH wrote:

Looking to use something to determine
name of control with focus in A97 app.

Is there something like Screen.currentcontrol.Name?

[Lyle Fairfield]

jb********@aol.com wrote in news:1158155224.406145.199240
@i42g2000cwa.googlegroups.com:

MLH

Screen.ActiveControl.Name

HTH

Jeff

MLH wrote:

>Looking to use something to determine
name of control with focus in A97 app.

Is there something like Screen.currentcontrol.Name?

Is there something like Help File?
How about Object Browser?

Has anyone ever explained their use to MLH?

--
Lyle Fairfield

[Terry Kreft]

Lyle,
I think you're looking at:-
Dim MLH As User
Set MLH = New User

With MLH
If .CantRemember Or .DontKnow Then
.PostToNewsGroup
Else
.PostToNewsGroupAnyWay
End If
End With
Whereas what you want is:-
Dim NewMLH As Programmer
Set NewMLH = New Programmer

With NewMLH
If .CantRemember Or .DontKnow Then
If .LookInHelpFile = Fail Then
If .LookInGoogle = Fail Then
.PostToNewsGroup
End If
End If
End If
End With

Set NewMLH = Nothing

Note the importance of tearing down the programmer object which you can't do
with the User object, this of course causes a memory leak the consequences
of which are shown in the code above.

--

Terry Kreft
"Lyle Fairfield" <ly***********@aim.comwrote in message
news:Xn*********************************@216.221.8 1.119...

jb********@aol.com wrote in news:1158155224.406145.199240
@i42g2000cwa.googlegroups.com:

MLH

Screen.ActiveControl.Name

HTH

Jeff

MLH wrote:

Looking to use something to determine
name of control with focus in A97 app.

Is there something like Screen.currentcontrol.Name?

Is there something like Help File?
How about Object Browser?

Has anyone ever explained their use to MLH?

--
Lyle Fairfield