View Single Post
 
Old 12-17-2017, 09:37 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Try
Code:
Private Sub UserForm_Click()

    Dim strTestValue As String
    
    strTestValue = "This is the test value"
    
    With UserForm2
        .Label1.Caption = strTestValue
        .Show
    End With

End Sub
Reply With Quote