vba courses london - VBA - progress bar

Resolved · Low Priority · Version Standard

Thu 24 May 2007, 15:55 Delegate Paul said...

Paul has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

VBA - progress bar

How do you get a graphical progress bar? E.g. the blue bar you get when you download from the internet
Thanks

Tue 29 May 2007, 19:03 Trainer Roy said...

RE: VBA - progress bar

When you're creating a User Form (in Excel VBA), you have the Controls Toolbox visible. Right-click on the background of the Toolbox and pick Additional Controls... The check the Microsoft Progress Bar control and OK. You then add this to a form, and set properties, as usual. There are tutorials out there in webland that provide more information.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips