vba courses london - VBA - progress bar

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

VBA - progress bar

Paul has attended:
Excel VBA course
Excel VBA Advanced course

by - delegate Paul [3 posts] (2007 May 24 Thu, 15:55) Reply

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

RE: VBA - progress bar

by - trainer Roy [23 posts] (2007 May 29 Tue, 19:03) Reply

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.

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips