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