hi,

would you like to give me an example to show how to use Progressbar in a
form.


thanks

you

There is a nice one at
http://www.enhanceddatasystems.com/E...rogressBar.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"EXCEL$B!!(BNEWS" wrote in message
...

hi,

would you like to give me an example to show how to use Progressbar in a
form.


thanks

you

this code in a userform with a command button (btnStart) and a progress bar
control (ProgressBar1)

Option Explicit

Private Sub btnStart_Click()
Dim i As Long
Dim t As Long
With ProgressBar1
.Max = 1000
.Value = 0
End With
For i = 1 To 1000
Me.Repaint
t = Timer
Do
DoEvents
Loop Until Timer < (t + 1)
ProgressBar1.Value = i
Next
MsgBox "Done"
End Sub

"EXCEL　NEWS" wrote:


hi,

would you like to give me an example to show how to use Progressbar in a
form.


thanks

you

You will a method by searching on "Progres bar" at john Walkenbach's site:
j-walk.com/ss/

"EXCEL　NEWS" wrote:


hi,

would you like to give me an example to show how to use Progressbar in a
form.


thanks

you

Have a look at the books of John Walkenbach :

In his book "Excel 2002(2003) Power Programming with VBA" there's an
example of this progressbar

find it at :
http://j-walk.com/ss/books/index.htm

http://www.j-walk.com/ss/excel/tips/tip34.htm
Displaying a Progress Indicator

--
Regards,
Tom Ogilvy

"David" wrote in message
...
You will a method by searching on "Progres bar" at john Walkenbach's site:
j-walk.com/ss/

"EXCEL?NEWS" wrote:


hi,

would you like to give me an example to show how to use Progressbar in a
form.


thanks

you

Also, on line at John's site:

http://www.j-walk.com/ss/excel/tips/tip34.htm
Displaying a Progress Indicator

--
Regards,
Tom Ogilvy


"baj" wrote in message
oups.com...
Have a look at the books of John Walkenbach :

In his book "Excel 2002(2003) Power Programming with VBA" there's an
example of this progressbar

find it at :
http://j-walk.com/ss/books/index.htm

you just said that

Perhaps if you read the portions of the threads I was reply to, you would
see that even though the same link was provided, it was provided in a
separate context. While it may appear redundant to someone sounding out the
words, I did have a purpose in doing it. Thanks for your interest.

--
Regards,
Tom Ogilvy





"damorrison" wrote in message
ups.com...
you just said that