Userform problem

  • Thread starter Thread starter racudd
  • Start date Start date
R

racudd

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
 
Hi Raccudd,

Try soimething like:

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