-
I am submitting data to an excel spreadsheet from VB and it takes time to complete after clikcing on the cmdSubmit
I placed a progress bar to show the progress ...
This is what happens:
I click on the command button and then the hour glass appears (at this time, I want my progress bar to be working) once the hour glass vanishes the progress bar will run..
Can anyone please help me????
Steve
-
somethng like:
Code:
If Form1.MousePointer = "11" Then
'progress bar code
Else
'stop progress bar code
End If
Or is it the progress bar code that you need?
D!m
-
<?>
If possible you should display your code. It might help others see the problem at a glance instead of wondering what the problem might be.
-
Progress Bar Reply
Thank you both...
I do not code for the progress bar...
What happens is when I click on the button nothing happens for a minute or so and then the code for the progress bar runs... at this point it is too late..
i am putting this in the cmdbutton
pg1.Value = 0
pg1.Visible = True
tmrProgress.Interval = 1000
I tried this :
If frmExpense2.MousePointer = "11" Then
pg1.Value = 0
pg1.Visible = True
tmrProgress.Interval = 1000
Else
'stop progress bar code
End If
but i am not always getting the hour glass... just the mousepointer..
Can you please help Steve