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.

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/Ins...l/Default.html
Last updated August 2003


-----Original Message-----
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.
.

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
----------------------------------------------------------





(scott) wrote in message . com...
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.