View Single Post
 
Old 05-12-2019, 08:44 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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