hunsnowboard
02-08-2009, 11:55 AM
Hi Everyone! I have this annoying problem with shapes. Please see the attached file.
My problem is the following:
On Sheet1 I have two important cells (C3 and D3). C3 is green and D3 is blue. C3 shows an outcome of a difficult counting which is not relevant to this problem. So C3 shows a percentage outcome. And based on the outcome of C3 I would like D3 to show a shape. These shapes are pie chart shapes. On the worksheet JPG you can see these shapes which are named: A, B, C, D, E and F. (i did not add all the shapes). As you can see each shape stands for an amount range (for example shape B stands for 0,001 and 0,05). So if on Sheet1 the outcome of C3 is between 0,001 and 0,5, range D3 should show shape B. Of course as this macro is run many times, each time the outcome is different, the macro should show the relevant shape. Now, I really do not know how to begin, how to write the code, as I am new, and besides I have never worked with shapes. Any ideas, thoughts? Please help if you can! Thank you in advance!
My problem is the following:
On Sheet1 I have two important cells (C3 and D3). C3 is green and D3 is blue. C3 shows an outcome of a difficult counting which is not relevant to this problem. So C3 shows a percentage outcome. And based on the outcome of C3 I would like D3 to show a shape. These shapes are pie chart shapes. On the worksheet JPG you can see these shapes which are named: A, B, C, D, E and F. (i did not add all the shapes). As you can see each shape stands for an amount range (for example shape B stands for 0,001 and 0,05). So if on Sheet1 the outcome of C3 is between 0,001 and 0,5, range D3 should show shape B. Of course as this macro is run many times, each time the outcome is different, the macro should show the relevant shape. Now, I really do not know how to begin, how to write the code, as I am new, and besides I have never worked with shapes. Any ideas, thoughts? Please help if you can! Thank you in advance!