pop up "loading"

**Raanan** · 10-15-2013, 05:06 AM

I have a dashboard that updates information form a raw file that opens and hides alongside it.

Is there a way I can have a pop up (message box type thing) that is a sort of "loading" screen so that users dont try do anything whilst calculations are being performed.

(excel 2007 the calculation thing at the bottom isn't enough

)

what i mean is i have a progress bar that just looks good! I need one that updates WITH calculation bar if possible. Or loads in the front whilst calculating.

**Olly** · 10-15-2013, 06:01 AM

A modeless userform would do what you want.

**Raanan** · 10-15-2013, 06:53 AM

oh.. right..

ha ok..

I can read up on specifically what that means..

I assume it will pop up whilst XL does its things then close when done (or when I set it)

**Raanan** · 10-15-2013, 08:04 AM

Ok slight problem. the code im using for it keeps bringing an error if i try modeless

Please Login or Register  to view this content.

Run-time error '50290': Method 'ScreenUpdating' of object '_Application' failed...

I guess I cant have modeless and the progress bar to update like that?

Whats the best way for it