ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Message box during data load (https://www.excelbanter.com/excel-programming/333624-message-box-during-data-load.html)

Dr.Schwartz

Message box during data load
 
My code performs a quiry in Oracle, however it takes a while. Of course the
hourglass shows up during the quiry, but I would like something a bit more
informative. Is it possible to perhaps display a message while the quiry runs
and that automatically is removed afterwards - all without any user
intervention?

Thanks
The Doctor

Norman Jones

Message box during data load
 
Hi Dr. Schwartz,

Try:

Application.StatusBar = "Query running, please be patient..."
'Your query code
Application.StatusBar = False

---
Regards,
Norman



"Dr.Schwartz" wrote in message
...
My code performs a quiry in Oracle, however it takes a while. Of course
the
hourglass shows up during the quiry, but I would like something a bit more
informative. Is it possible to perhaps display a message while the quiry
runs
and that automatically is removed afterwards - all without any user
intervention?

Thanks
The Doctor





All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com