Progress Bar - Delay then works

[StevenH]

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

[Dim]

somethng like:

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

[HeSaidJoe]

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.

[StevenH]

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