Assigning a string variable to a userform label caption

Larry_1 · #1 12-17-2017, 07:01 AM

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 Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to have two formats in the Caption style: Label – number - text?	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
Custom caption list label lost in a new Word session	New Daddy	Word	1	09-22-2013 09:21 AM
Custom caption label annoyance	zac	Word	1	08-29-2010 09:56 AM