vba courses london - Message Box

Resolved · Low Priority · Version Standard

Thu 15 Feb 2007, 10:39 Delegate Andrew said...

Andrew has attended:
Excel VBA Intro Intermediate course

Message Box

What is a messgage box and how are they used?

Thu 15 Feb 2007, 13:12 Trainer Garry said...

RE: Message Box

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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

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