![]() |
#14
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
clip art with embeded textbox | Mel Spence | Misc | 0 | 05-19-2013 09:38 AM |
![]() |
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 |