UserForm1 only shows Caption text, nothing else

[Swaroon]

Hi,

I have a macro which loads a Userform, the form seems to load ok in that when the macro runs, I see the form appear and then disappear as per the macro instructions.

The problem is all I see on the form when it runs is the text I've entered into the caption box in the properties, nothing else is showing - I've checked that I haven't got while lines / text on a white background.

I've tried to display labels, frames etc, but nothing shows, only the caption box and what looks like an empty form below the caption.

Any ideas ?

thanks
Steve

 

[Von Pookie]

If I am understanding correctly: do you have the macro running in the background while displaying a modeless userform?

If this is the case, what I do is 'repaint' the screen.
For example:

UserForm1.Show
UserForm1.Repaint
'code runs
Unload UserForm1

The explanation of repaint from the VBA help file:

Updates the display by redrawing the form or page.
...
The Repaint method is useful if the contents or appearance of an object changes significantly, and you don't want to wait until the system automatically repaints the area.

 

[Swaroon]

Hi Kirsty,

You were correct - macro running in the background while displaying a modeless userform - I used your code and the userform now displays.

Thanks for yor help, really appreciate it.

Steve