I'm trying to make a dynamic map, where if I choose from a drop down list, a cell will show a specific text, and that will prompt the shape I use for the map to become visible.
My method is using a base map, the selected shape that appear will cover the base map, making it look like the selected region is highlighted. I have named my shapes and put them in a list labeled Region 1, Region 2, Region 3, so on. I plan for the shapes to be transparent in the first place, and only appear when the reference cell calls for it, which will be prompted by the drop down cell.
I am just beginning to learn VBA so everything is very new to me. I don't have background in coding, but I can vaguely guess what is happening in the codes. As you may see below, my changes are very basic and amateurish.
So far there is no error showing, but the codes do not work either.
Any help would be greatly appreciated, thanks.
SOLVED: I had put the codes in module instead of the worksheet itself. The code is fine and it works. I have re-upload the corrected file if people want to see.
Bookmarks