Thematic Map

[leveyc]

Hi

I have a map of North America that shows current data by coloring the states based on a number range, some basic excel calculations and a few lines of VB, really do not know much about VB....what I would like to do is have the ability to scroll through columns of data, so each time you scroll the color of the states change.....I can send you the file if needed

Any help greatly appreciated

Charlie

[Simon Lloyd]

Just attach your file here, go to "Go Advanced", scroll down "Manage attachments" and attach your file, we'll see what we can do :)

[leveyc]

Here you go and thanks

[Bob Phillips]

Try this

[leveyc]

This is great..Thanks..would there be away to remove the button and have the map change based on the list selection?

Thanks again

[leveyc]

I did manage to have the map change based on the selection from the list you inserted, I moved the logic to another tab which I can hide but can not get the list to work now, its as if its tied to the original cells??

[Bob Phillips]

Here you are

[leveyc]

Thanks to everyone for your help, first time I have used this forum....so I have one last question, if I wanted an option to have this to auto scroll through the months, is that a big deal to accomplish?

Thank again

[Bob Phillips]

Depends upon what you mean by scroll through the months.