Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 01-31-2014, 07:22 AM
gmaxey gmaxey is offline Find textbox name Windows 7 32bit Find textbox name Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

IF you want the textbox to return its name when you click in it use:

Private Sub Document_City_Enter()
MsgBox Me.Document_City.Name
End Sub

as previously provided, or

Private Sub Document_City_Enter()
MsgBox Me.ActiveConrol.Name
End Sub

as Paul provides, or

If you click a command button Document_City obviously no longer has the focus so:

Private Sub cmdTextBoxName_Enter()
MsgBox Me.ActiveControl.Name
End Sub

Naturally returns cmdTextBoxName, because cmdTextBoxName is now the active control.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
clip art with embeded textbox Mel Spence Misc 0 05-19-2013 09:38 AM
Find textbox name 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft