Excel and VBA UserForm - what a hell is going on?

[valtersp]

Hi all!

There are some very strange things going on with Excel's VBA UserForms.

1st - when designing an UserForm, sometimes it becomes corrupted and I don't know, why (expecially, when save excel file as an add-in and edit it later).
2nd - all captions, which are used to name form's controls suddenly disappears after you NORMALLY save & exit (not by pressing ctrl+alt+del on PC's or cmd+opt+esc on MAC's).
But the 3rd is the most... surprising. UserForm "remembers" values previous user input in if Excel not quitted. I've placed a code, setting all values to "" when form Activate/Initialize, but - no cigar!
The strangest thing is - when user form is closed and opened once more, all values are set to "", as it should be.

Can anyone tell me, what is going on in UserForms and how to avoid these oddities.

Thanks!

 

[xlbo]

1: It's excel, it's made by M$ - you're surprised ???
2: dunno
3: Be very careful with forms as to whether you are HIDING or UNLOADING them
If you hide, the initialise event will not kick in when the form re-opens but the activate event will
Rgds
~Geoff~