Hi, today is my first day trying to use macros/VBA. I want to create a really simple (I hope) macro that goes something like this:
In Sheet1 I have inserted a rectangle shape. I have then assigned a macro as such;
I have then inserted another rectangle shape in Sheet1. I have assigned a macro to that as such;
What I want to be able to do is have only one rectangle shape so that when I click it, G11 says "The Example" and then when I click it again, G11 is cleared. By extension, once it is cleared, if I were to click it again, it would then again say "The Example" again, and so on and so on. I have been trying to google this but have come up with nothing so far, except the two separate shapes as described above. Can anyone help please? Thanks (and apologies if this is quite trivial).
Bookmarks