Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
vba courses london - excel vba

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Excel VBA

vba courses london - Excel VBA

ResolvedVersion Standard

Chris has attended:
Excel VBA Intro Intermediate course

Excel VBA

How can I redesign a command button?

RE: Excel VBA

Once you place a command button on a form you can change its properties. To do this:

Right click the button
Select Properties

In the Properties window change the values of the Back colour, Font and Style of the button to your desired look

VBA tip:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.