progress bar? how?

[19790203]

Let's have a time consuming code:

sub code()

'the first SQL query

'the second SQL query

end sub

How to put a progress bar with status changing after each SQL query is completed?

 

[shakespeare5677]

Put a progress bar on a form (ProgressBar1)
Set its max value to the number of queries to be executed.
Then:

sub code()

'the first SQL query
ProgressBar1.value = ProgressBar1.value + 1

'the second SQL query
ProgressBar1.value = ProgressBar1.value + 1

end sub

-Max

 

[19790203]

But I meant a progress bar in VB for Excel.. I'm trying to find more relevant info in VB Excel help but with no result :/

 

[shakespeare5677]

I did not realize this was a VBA question. You're probably better off posting in a VBA forum.
-Max