Felix Atagong
Active Member
- Joined
- Jun 27, 2003
- Messages
- 359
I just lost 45 minutes completely rewriting a UserForm because there seemed to be an error in it. I played with Load, Unload, Show and Hide, put in some If Then Elses but it only worked 1 time out of 2. And I couldn't find why...
Then after 45 minutes I had a moment of clarity and took a closer look at my macro that triggered the UserForm. My UserForm had 2 possible flags as OptionButtons (V and L) while my macro only accepted V or B. Everytime the macro encountered the L-flag it opened the UserForm again and again and again...
Thank God it's Friday!
Then after 45 minutes I had a moment of clarity and took a closer look at my macro that triggered the UserForm. My UserForm had 2 possible flags as OptionButtons (V and L) while my macro only accepted V or B. Everytime the macro encountered the L-flag it opened the UserForm again and again and again...
Thank God it's Friday!