Change Default Label Caption with VBA

Hi, I'm having trouble figuring out how to get a label caption change to 'Stick'

I'd like to make the label change 'permanent' when I execute a particular event.

If my default label is "Hello" and I execute the below, it will change to "World" until I close the userform. Upon executing, I'd like to change the default caption so the next time the form opens, it will say "World."

Please Login or Register  to view this content.

I've dug around a bit and have seen some code like the below, but haven't been able to get it do do anything other than the code above.

Please Login or Register  to view this content.

Thanks in advance

Ya, this is simplified to the root of what I'm trying to accomplish....essentially I have a ticketing system. Request -->Approval-->Approval kicks out several files, one of which is a new excel file with the userform with a header label caption locked in with the ticket number.

I can always put something into a very hidden sheet/etc but I was wondering if I could accomplish a "clean" file generation.

That's IT!! Thanks!