VBA splash screen

[scott]

I have a pivot table linked to an OLAP cube. Is there any way to
create through VBA a small form that appears while the cube is
refreshing and disappears when it is finished. Maybe saying something
like "....Please wait." Any help would be appreciated. Thanks.

 

[dermot]

I have examples on my site below, also see the sample
code for providing user feedback

Dermot Balson
Free VBA code for user interfaces, internet connectivity,
encryption
http://www.webace.com.au/~balson/InsaneExcel/Default.html
Last updated August 2003

 

[BrianB]

Easy. Put a textbox on screen and remove it with code (record a
macro).

Add a line of code after the textbox is added like
[Activesheet.Range("A1").Select] to take focus away from it otherwise
you get strange results with the formatting.


Regards
BrianB
----------------------------------------------------------