Microsoft Office Forums - View Single Post - [Solved] Have user form label assigned by variable?

gmaxey · 05-13-2019, 11:35 AM

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

It goes in the form module initialize event and you don't need "Me"

Code:

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