VBA Code for User Form

[dkesar]

I need help with setting up user form properties. I have calendar form and when I set properties form initializes just fine showing Month and Year as a title, drop down menus for Month and Year, day names and day numbers...all in font and color I have set using properties function. However, as soon as I move doc to another PC calendar initializes without Title, drop menus for year and month and looses font, its color and background color I have previously set before moving doc to another machine. My question is, is there vba code I can set this properties when form initialized...or even maybe on Workbook Open...?

[Admin]

yes, you can. For example...

Private Sub UserForm_Initialize()
    
    Me.TextBox1.Font.Size = [A1].Font.Size
    Me.TextBox1.BackColor = [A1].Interior.Color
    Me.TextBox1.ForeColor = [A1].Font.Color

End Sub