Thread: [Solved] Find textbox name
View Single Post
 
Old 01-30-2014, 02:46 PM
gmaxey gmaxey is offline Windows 7 32bit Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,601
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Well, if it is a textbox in a Userform, you pretty much have to know the name before you can do anything with it. For example, if you have a textbox named TextBox1, then you could use the Enter event for the named control:

Private Sub TextBox1_Enter()
MsgBox Me.TextBox1.Name
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote