Waiting Mode when query data from Db via VBA!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
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 ?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing query data via vba button 2
Exporting data with vba from Excel to an Access 2007 db with password 8
vba code does not run 3
Extracting Data from Access dB to Excel, using VBA 3
Programatically open Access DB with user level security 1
Running a SQL query off an excel table of data 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
QueryTables, some basic questions 5

Back
Top