Excel Crazy

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 15, 2012

0 responses on "See the Recorded Syntax"

Leave a Message

Your email address will not be published. Required fields are marked *


© LOKESH PALIWAL 1987 - 2018


Reporting Solutions | Data Consulting | Analytics Training

close slider

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Message for us...

Skip to toolbar