Thread: [Solved] Find textbox name
View Single Post
 
Old 01-31-2014, 05:38 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In your previous reply, you said:
Quote:
Originally Posted by Hdata View Post
The textboxes I am working with are called VBA textboxes and not a Windows Form textbox.
From that, I would have thought they were not userform textboxes. But this:
Quote:
Originally Posted by Hdata View Post
They are created in Office 2010 vba from the userform where I click the textbox control from the toolbox.
indicates otherwise. For a userform control, all you need is an 'Enter' event, coded like:
Code:
Private Sub TextBox1_Enter()
MsgBox Me.ActiveControl.Name
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote