Have user form label assigned by variable?

05-12-2019, 08:44 PM

Guessed

Windows 10 Have user form label assigned by variable?

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,185

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

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:30 AM.