Hello, I just joined this sight and am very new to VBA. I am currently in the process of trying to understand the function. I am in request of a code that would change the Shape Fill color based on cells drop down menu value, the values are 4mm, 6mm, 8mm, and stop". The code I am looking for function would take the value from the cells in the "Z" column and turn the specific oval either blue, red, yellow, or green. I tried to use a code similar to what i was looking for but I had no luck when putting in my data.
any help or a point in the correct direction would be greatly appreciated
I have attached a sample file to this thread.
Bookmarks