1 Attachment(s)
Help! please! CHANGING SHAPE COLORS IN POWERPOINT WITH A DATABASE
HELP!! Hello, I've a map in powerpoint 2019, each division of the map is a shape, and I've to change the fill color of each one of thoseAttachment 26545 shapes according to a query from an Access database, I'm new in VBA with some knowlege of VB, there are only 125 shapes. any ideas? I'm attaching the pptx file with the map.
thasnk alot for the help
2 Attachment(s)
posting access data base! thanks XLD
Hello XLD, thanks for your reply, I'm posting the access database, it has a table named catmun with 3 fields:
cvemun=key from 1 to 125, referencing to a municipality in the map
covid19_range= only 3 values: A, B and C depending on this value the corresponding shape has to fill with a selected color, the value in this field will be dynamyc.
Shape: the name of the shape that has to be filled with a selected color on the powerpoint's map according to the covid19_range value.
Thanks again for the help.Attachment 26560