I've been wrestling with what is probably a simple problem. I have a map of the US on one worksheet
with shapes (circles) over locations where our company has resources. I've put in a button on that sheet that toggles the
shape on or off using the .visible = true or .visible = false properties. This button also has a caption that toggles as
well. However, I also want to dictate the size of those shapes based on values entered in another worksheet in the same
workbook. I've tried and just can't get it to work. Here's the kind of code I am using to toggle the visibility. I'd like to
insert code into this event that will also adjust the circle size based on value in a cell. Thanks!
Private Sub CommandButton5_Click()
If CommandButton5.Caption = "Hide" Then
CommandButton5.Caption = "Show"
ActiveSheet.Shapes("Oval 1_LosAngeles").Visible = False
If CommandButton5.Caption = "Show" Then
CommandButton5.Caption = "Hide"
ActiveSheet.Shapes("Oval 1_LosAngeles").Visible = True