vbModeless form problem?

**tom_19** · 08-25-2011, 04:16 PM

Hello -

I feel like this should be a relatively easy fix. I am trying to show a quick and dirty form (which simply says "please wait...") when a user clicks a button. The particular macro I'm working with takes about 3-4 seconds to run. I tried to figure this out using a Google search, but I'm not having any luck. The code I have now is:

frmPleaseWait.Show vbModeless

< all my other code is here>

Unload frmPleaseWait

I am using vbModeless because I want the rest of my code to execute in the background of this form being displayed so the user doesn't have to click anything to allow the code to continue. The form comes up entire white on my screen though, and it should have a grey background with the text "Please wait..."

Thoughts? Ideas? Am I doing something wrong?

**Colin Legg** · 08-25-2011, 04:17 PM

Hi Tom,

Try:

frmPleaseWait.Show vbModeless

frmPleaseWait.Repaint
< all my other code is here>

Unload frmPleaseWait

**tom_19** · 08-25-2011, 04:28 PM

Thanks Colin! That did the trick. Any idea why this was happening? Could I be doing something wrong or have a property set incorrectly, or is this just a known nuance of Excel?

**Colin Legg** · 08-25-2011, 04:30 PM

Hi Tom,

You're not doing anything wrong. You've just got to give Excel the resources to paint the userform correctly on the screen and explicitly calling RePaint is the cleanest way to do it. Another way, which is not quite as clean, is to use DoEvents.