Waiting Mode when query data from Db via VBA!
 

I need to query data from DB via VBA in Excel. This step will costed a few of
seconds. End-User will only wait for result without action. Maybe this time
of this section may be long time. Does VBA provide a way to pop-up a window
which included some message to notice End-User the programmer is running. For
example, When I click a button which query data from DB, a window will appear
with no buttion, it will disappear automatically when the data is retrieved.
--
Developer
QA Dashboard
Microsoft China Development Centre

Waiting Mode when query data from Db via VBA!
 

This may help:

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"Microlong" wrote in message
...
I need to query data from DB via VBA in Excel. This step will costed a few
of
seconds. End-User will only wait for result without action. Maybe this
time
of this section may be long time. Does VBA provide a way to pop-up a
window
which included some message to notice End-User the programmer is running.
For
example, When I click a button which query data from DB, a window will
appear
with no buttion, it will disappear automatically when the data is
retrieved.
--
Developer
QA Dashboard
Microsoft China Development Centre

Waiting Mode when query data from Db via VBA!
 

Why is the version lewer 9? Can this code run on Excel 2003? but I can't get
any impact in Excel 2003. Do you offer more help ?

"Robin Hammond" wrote:

This may help:

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"Microlong" wrote in message
...
I need to query data from DB via VBA in Excel. This step will costed a few
of
seconds. End-User will only wait for result without action. Maybe this
time
of this section may be long time. Does VBA provide a way to pop-up a
window
which included some message to notice End-User the programmer is running.
For
example, When I click a button which query data from DB, a window will
appear
with no buttion, it will disappear automatically when the data is
retrieved.
--
Developer
QA Dashboard
Microsoft China Development Centre

Waiting Mode when query data from Db via VBA!
 

Not sure what you have done, but if you downloaded the right file you can
run the prog bar demo.

Robin Hammond
www.enhanceddatasystems.com

"Microlong" wrote in message
...
Why is the version lewer 9? Can this code run on Excel 2003? but I can't
get
any impact in Excel 2003. Do you offer more help ?

"Robin Hammond" wrote:

This may help:

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"Microlong" wrote in message
...
I need to query data from DB via VBA in Excel. This step will costed a
few
of
seconds. End-User will only wait for result without action. Maybe this
time
of this section may be long time. Does VBA provide a way to pop-up a
window
which included some message to notice End-User the programmer is
running.
For
example, When I click a button which query data from DB, a window will
appear
with no buttion, it will disappear automatically when the data is
retrieved.
--
Developer
QA Dashboard
Microsoft China Development Centre

Waiting Mode when query data from Db via VBA!
 

I have done it, thank for your help!
"Robin Hammond" wrote:

Not sure what you have done, but if you downloaded the right file you can
run the prog bar demo.

Robin Hammond
www.enhanceddatasystems.com

"Microlong" wrote in message
...
Why is the version lewer 9? Can this code run on Excel 2003? but I can't
get
any impact in Excel 2003. Do you offer more help ?

"Robin Hammond" wrote:

This may help:

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"Microlong" wrote in message
...
I need to query data from DB via VBA in Excel. This step will costed a
few
of
seconds. End-User will only wait for result without action. Maybe this
time
of this section may be long time. Does VBA provide a way to pop-up a
window
which included some message to notice End-User the programmer is
running.
For
example, When I click a button which query data from DB, a window will
appear
with no buttion, it will disappear automatically when the data is
retrieved.
--
Developer
QA Dashboard
Microsoft China Development Centre