Change color of shape with vba

[ahmadyan63]

hi all,
I have several shapes in a sheet1 and now for each shape i have defined a userform which put some values in sheet2 now i want to change the color of each shape when the specified cells in sheet2 get value. how can i use vba to do this
thanks

[walruseggman]

Here's how to change the color of "Oval 1" on sheet one by inputting a RGB integer (e.g. 65142) into cell A1 on Sheet 2. Not sure if it's the best way, as I rarely deal with shapes, but it's tested as working.

Please Login or Register  to view this content.