Nov 15, 2005 #1 19790203 Programmer Joined Oct 7, 2005 Messages 13 Location PL 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?
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?
Nov 15, 2005 #2 shakespeare5677 Programmer Joined Jul 18, 2005 Messages 284 Location US Put a progress bar on a form (ProgressBar1) Set its max value to the number of queries to be executed. Then: Code: sub code() 'the first SQL query ProgressBar1.value = ProgressBar1.value + 1 'the second SQL query ProgressBar1.value = ProgressBar1.value + 1 end sub -Max Upvote 0 Downvote
Put a progress bar on a form (ProgressBar1) Set its max value to the number of queries to be executed. Then: Code: sub code() 'the first SQL query ProgressBar1.value = ProgressBar1.value + 1 'the second SQL query ProgressBar1.value = ProgressBar1.value + 1 end sub -Max
Nov 15, 2005 Thread starter #3 19790203 Programmer Joined Oct 7, 2005 Messages 13 Location PL 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 :/ Upvote 0 Downvote
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 :/
Nov 15, 2005 #4 shakespeare5677 Programmer Joined Jul 18, 2005 Messages 284 Location US I did not realize this was a VBA question. You're probably better off posting in a VBA forum. -Max Upvote 0 Downvote