![]() |
#1
|
|||
|
|||
![]()
I a beginner with Excel.
I've created UserForm1 with 3 labels and 3 textboxes (email, first name, last name), captured the entries and validated them. I then wanted to use those values as captions in UserForm 2. But I couldn't make UserForm2 work. So I created a simple test form to try it, and couldn't make that work either. I've tried both a hard coded string and a simple string variable. Neither worked. I placed this code in the VBA area attached to the UserForm. I would sincerely appreciate any suggestions that you can offer. Very respectfully, Larry Code:
Private Sub UserForm_Click() Dim strTestValue As String strTestValue = "This is the test value" Label1.Caption = strTestValue 'Label1.Caption = "This is the soft entered Msg" 'Me.Label1.Caption = strTestValue End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jamal NUMAN | Word | 39 | 03-14-2017 06:32 PM |
Assigning Form.ActiveControl.Name to variable | aramaglia | Excel Programming | 0 | 02-10-2017 09:57 AM |
Userform label bordercolor not controllable if click label | skarden | Word VBA | 1 | 09-29-2013 07:27 PM |
![]() |
New Daddy | Word | 1 | 09-22-2013 09:21 AM |
Custom caption label annoyance | zac | Word | 1 | 08-29-2010 09:56 AM |