Prev: How do I add numbers in two column based on the date in another?
Next: Conditional Formatting VBA Multiple Numeric Ranges
From: Mishell on 10 Mar 2010 12:46 Put your DoEvents after showing the form. UserForm1.Show vbModeless DoEvents Mishell "Lucky" <kingofwhiles(a)aol.com> a �crit dans le message de news: 16938c9e-9a79-426a-ba13-e6eccc4a35db(a)e7g2000yqf.googlegroups.com... >I want a modeless user form to appear, then my program does some work > (clearing the screens of all drawing objects, which takes a while), > and then the user form to unload. I've gotten this to work, except > that the user form is completely blank and white. The label control > with my message doesn't show. I've tried DoEvents before showing the > form, repaint in the form initalize (as suggested in other posts on > this topic), and this doesn't help.
From: Lucky on 10 Mar 2010 14:38
Wow, Mishell, that did it. Thanks! |