Hi to all!
I have a list of products in sheet1.
In sheet2, I have some shapes linked to every product name on sheet1. I need that some shapes change its background color, based on their values. For examples if a shape's value is "PRODUCT ALFA", I Need that shape that contains the word ALFA, colora its background in a color, for example that.
How can I achieve this with Vba for all the shapes on my sheet?
Bookmarks