Excel - UserForms

  BWM 15:51 15 May 06
Locked

I am trying to add a VBA user form to show progress when running a long macro. However when I try to load it the frame of the form appears but neither the background colour or the fields show until the macro has run. The form is set to non modal and I have not turned off the screen re-fresh. I have tested the macro on different PCs and I get the same result. I am using Excel 2003. does anyone have any idea why this is happening?

  VoG II 17:36 15 May 06

Not sure without seeing the code.

However see click here 'Control the LED Display in the StatusBar' which I think is much neater than using a modeless Userform.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…