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

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

--
racud
-----------------------------------------------------------------------
racudd's Profile: http://www.excelforum.com/member.php...fo&userid=3350
View this thread: http://www.excelforum.com/showthread.php?threadid=53303

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

Man, that was simple. Thanks, but now I feel a little stupid.:

--
racud
-----------------------------------------------------------------------
racudd's Profile: http://www.excelforum.com/member.php...fo&userid=3350
View this thread: http://www.excelforum.com/showthread.php?threadid=53303