Find textbox name

macropod · #11 01-31-2014, 05:38 AM

In your previous reply, you said:

Quote:

Originally Posted by Hdata

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
clip art with embeded textbox	Mel Spence	Misc	0	05-19-2013 09:38 AM
Display result in textbox based on the input of another textbox	scarymovie	Word VBA	5	05-16-2012 07:05 PM
textbox color issue	Dave Duncan	Word	0	08-07-2011 10:38 AM
Textbox Template	t0m46	Word	0	09-07-2010 03:38 AM
Creating Chart using VB textbox value	shyler82	Word VBA	0	03-12-2010 06:56 PM