Notice: WC_Cart::get_cart_url is deprecated since version 2.5! Use wc_get_cart_url instead. in /home/swatipaliwal/public_html/excelcrazy.com/wp-includes/functions.php on line 3839
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 *

top
 

© LOKESH PALIWAL 1987 - 2017

Reporting Solutions | Data Consulting | Analytics Training