Hello all,

I would like to ask for help regarding the following issue.

I am making an interactive map. It contains two sheets: first one is the map with line shapes, second one is the database. I would like to add a colour-coding function according to the line shapes which shall based on the values given in the database.

I have made a plan for the better understanding:
http://www.speedyshare.com/gWJwd/plan.xlsm

So for example if you push "A parameter" button, all line shapes shall change their colours according to the values in the database under "A parameter": if its 10, line shall be red, and so on.

Can someone help me which codes should I use?

Thanks in advance!