Have user form label assigned by variable?

Guessed · #8 05-12-2019, 08:44 PM

You are right, my second code guess doesn't work. so you should go back to my original suggestion of using the Initialize macro
In ThisDocument change the macro to

Code:

Private Sub Document_New()
  'Automatically runs when this document is opened.
  formMain.Show
End Sub

In the Userform itself, add this macro

Code:

Private Sub UserForm_Initialize()
    Me.optSch1.Caption = "School One"
    Me.optSch2.Caption = "School Two"
    Me.optSch3.Caption = "School Three"
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning a string variable to a userform label caption	Larry_1	Excel Programming	3	12-18-2017 06:59 AM
MACRO in infinite loop when it encounters user defined figure label	photoval	Word VBA	3	02-02-2016 08:26 PM
Variable arrays from user input	SeattleITguy	Excel Programming	1	01-29-2015 09:19 AM
User input to a variable on the document	dsm1995gst	Word VBA	1	09-03-2013 03:43 PM
Task Form disappearing when assigned	zoids	Outlook	0	03-27-2011 05:01 PM