Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-17-2017, 07:01 AM
Larry_1 Larry_1 is offline Assigning a string variable to a userform label caption Windows 10 Assigning a string variable to a userform label caption Office 2010 64bit
Novice
Assigning a string variable to a userform label caption
 
Join Date: Dec 2017
Posts: 9
Larry_1 is on a distinguished road
Default Assigning a string variable to a userform label caption

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning a string variable to a userform label caption 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
Assigning a string variable to a userform label caption 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 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