UserForm Label Caption

[GRCArizona]

Hi -

I've got a UF that has a label. The default label caption is a date (Jan 1, 2012). Using the Initialize event, I'm running some code that checks for a value on a worksheet. If the code finds the value, the Label.Caption changes to Feb 1, 2012. I can see this change while I'm running my UserForm and it appears to working correctly, but once I close the UF, and go back into VBA, the Caption property still has Jan 1, 2012.

does anyone know why the Caption Property is not changing / saving?

BTW, I'm using Unload Me on a commandbutton to close the UF.

thanks,

GRC

 

[Dave Punky]

The way I understand it, the .Caption (and indeed all the properties) has a "default" value that you set within VBA and then any changes need to be made via Subs / Functions once the form is active. Once you unload the form, the information would revert back to the "default" information.

That's how it's always been for me at any rate although - I think it's standard because it'd be quite frustrating to change the default values of something back if you inadvertently changed them via Subs to begin with without realising it.