Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Website, DB, & Software Developers

(3,270 posts)

4. Worked fine in Office 2010

Fri Jan 27, 2012, 04:15 PM

Jan 2012

Looks like it has 50 Shape polygons and they are using the Shape.Fill command to modify the color.

The Workbook.Shapes property seems to be supported in versions 2003 VBA:
http://msdn.microsoft.com/en-us/library/aa174301%28v=office.11%29.aspx

and also 2005-2010:
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.shape_members.aspx

You may have to enable macros and scripts for the "update state colors" button to function.

Edit history

Please sign in to view edit histories.

0 members have recommended this reply (displayed in chronological order):

5 replies

= new reply since forum marked as read

Highlight:

Good way to make color coded map graphics? [View all] limpyhobbler Jan 2012 OP

Here is a way to do US States in MS Excel ChromeFoundry Jan 2012 #1

ok so limpyhobbler Jan 2012 #3

Worked fine in Office 2010 ChromeFoundry Jan 2012 #4

Using Google Maps ChromeFoundry Jan 2012 #2

I've done hundreds of them in MapInfo. It isn't cheap, but it works. HopeHoops Jan 2012 #5