Modeless User Form Is Blank
in [Programming]
|
Prev: How do I add numbers in two column based on the date in another?
Next: Conditional Formatting VBA Multiple Numeric Ranges
From: Lucky on 10 Mar 2010 10:27 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: joel on 10 Mar 2010 10:52 What controls did you add to the Userform using the toolbox in the VBA wndow menu? You should add either a Label or Text box and manually add the Text to the control. You don't need to do this inside a macro if you want the same message to appear everytime. Make sure you eliminate all the writes to the control in your macro. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=186288 [url="http://www.thecodecage.com/forumz/"]Excel Live Chat[/url]
From: Lucky on 10 Mar 2010 11:06 I put a label control on the form (using the toolbox when I set it up) with text that basically says "please wait". There is no code in the form's module, and I don't interact with the form while it is showing. I just want it to appear with the message, stay on the screen while I do some other work, then go away. Seems simple enough. It does appear, and when I finish the other work, it does go away. But it is blank.
From: joel on 10 Mar 2010 11:38 What you have should work. That is why I said to make sure you aren't writing to the control an erasing any text inside the control. You could also have the wrong color for the font that won't contrast with the userform color. You can veiw all the properties of the Userform and Control as follows. From VBa - View Properties Window. then either click on the userform or contrl and the properties for the object will show in the properties window. check the font color and background color to make sure the color will contrast so you can see the text. the text words should be seen in the control properties. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=186288 [url="http://www.thecodecage.com/forumz/"]Excel Live Chat[/url]
From: Lucky on 10 Mar 2010 12:07
Joel, Thanks for discussing this with me. I've made lots and lots of user forms, but this is the first time I've tried to use one as modeless. The form looks fine in design view, and as I said, I don't interact with it when it is on the screen. Screen updating is turned off by my code after the form is displayed, so it's already on the screen by that time, so it seems that it should be just fine. I'm at a loss as to why this is happening. My program is big and uses lots of shapes on lots of screens, so the only thing I can think of is that maybe I'm running out of memory. I've tried everything I can think of, so I guess I'll just dump the form and try something else, maybe using the status bar for my "please wait" message. Oh, well. Thanks again, Lucky |