I need to create a map and change the colors of the individual states based on cell values.

I was thinking of have 50 individual pictures/shapes/objects/whatever (1 for each state) and then use VBA to change the color of the individulas items.

Any ideas on how best to do something like this?

Thank...

JimS