Hi Raccudd,

Try soimething like:

'=============
Private Sub UserForm_Activate()
Me.Repaint
End Sub
'<<=============

---
Regards,
Norman



"racudd" wrote in
message ...

I've created a userform that I want to activate and then cover the
screen while a macro then searches and populates a database. This is a
rather lengthy macro, and I assume what is happening is that the
userform is not being loaded completely due to memory issues. The
userform loads, but the controls that I added to the userform do not
appear (I just get an empty white box).

The userform is loaded by a button, and I am using the
userform_activate command to then run the macro. Some of the code is
located with the userform, and I also have calls to other code located
in separate modules. Everything works great, I just can't get the
controls in the userform to appear. My goal was to not irritate the
user with having to look at the screen blinking and flickering while
the macro runs. Any thoughts?


--
racudd
------------------------------------------------------------------------
racudd's Profile:
http://www.excelforum.com/member.php...o&userid=33508
View this thread: http://www.excelforum.com/showthread...hreadid=533035