See the Recorded Syntax

See the Recorded Syntax

The recorded macro is ready for use.  Before we run the marco, let’s look into the syntax.

1. To load the Visual Basic Editor, press [Alt] and [F11] at the same time.  (Remember from our prior lesson?)  The Visual Basic Editor comes up.

2.  Expand the Modules folder in the Project Explorer by clicking on the plus (+) sign.

3.  Double click the Module1 folder to see the sub routine (marco).

As the figure shows, the name of the sub routine is “SetBackgroundColor”.   The color index for the light yellow is 36.  The background pattern is soild.

March 5, 2012

0 Responses on See the Recorded Syntax"

Leave a Message

© copyright www.excelcrazy.com. All rights reserved. Design and Development by www.creativebrainweb.com