Hi there,
I have some code that changes the color of an autoshape when clicked. This code also takes the text value inside and displays it in a separate cell. It works perfectly however I also want to only allow 1 shape to be colored in at a time (I want to use this as a type of audit form that has like 5 categories and you rate between 1-5 for each category. The shapes will be the 1-5 numbers and when you click on a shape it adds the value inside to your total score)
Another issue i see is that when i click on 1 shape, then click on another one, it takes the value of the second shape i clicked (which technically it should) but when i click the second shape again it still keeps that same value and doesnt use the value of the first shape that is still colored in. This is due to the fact that the code is just looking at the shape i am clicking on at the time.
Here is my code:
Any help is appreciated.
Bookmarks