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!
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!