vba courses london - Message Box

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

Resolved · Low Priority · Version Standard

Message Box

Andrew has attended:
Excel VBA course

by - delegate Andrew [1 post] (2007 Feb 15 Thu, 10:39) Reply

What is a messgage box and how are they used?

RE: Message Box

by - trainer Garry gold contributer [188 posts] (2007 Feb 15 Thu, 13:12) Reply

Message Box displays a message in a dialog box, that waits for the user to click a button, these are usually used as help or warning users of a process

· Should You Send Managers To VBA Training?
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· How To Find A Good VB For Access Trainer
· Company Roles in Visual Basic Training
· Visual Basic Returns To The Macintosh

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