Change name of UserForm in Visual Basic

[bdschleich]

I used the visual basic editor to set up a "splash page" window that is prompted to be displayed for 5 seconds each time that my excel spreadsheet is opened, but the top of the window that pops up says "UserForm1". Is there way to change this text?

 

[JASONW10]

This one is a easyone ok on your properites window you will see this on the Aplphabetic tab
(Name)
BackColor
BorderColor
BorderStyle
Caption Userform1 change this to what ever you want it to say

 

[bdschleich]

Great -thanks for your help. A related question: how do I change the color of the font in the pop-up window?

 

[JASONW10]

click on the userform not on any labels or textboxes, then look on properties
Background will change you color of the back ground of your userform
and so on check our your properties it never hurts to mess around in them to see what they do just save first