Have user form label assigned by variable?

Steve Kunkel · #11 05-13-2019, 01:10 PM

Quote:

Originally Posted by gmaxey

It didn't work because it was out of order:

Code:

Private Sub Document_New()
  With formMain
    .optSch1.Caption = "School One"
    .optSch2.Caption = "School Two"
    .optSch3.Caption = "School Three"
    .Show
  End With
End Sub

...

Actually... As I look at my first post at the top, I see that I didn't have With and End With.

Code:

private Sub Document_New()
   formMain.Controls(optSchl).Caption = "One High" 
   formMain.Controls(optSch2).Caption = "School Two" 
   formMain.Controls(optSch3).Caption = "Sch Three"
   formMain.Show 
End Sub

Perhaps this was causing the odd behavior of only one caption being populated (?) Like maybe lines 2, 3, and 4 were over-writing each other?

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