I am looking to click a shape and return a TRUE value in different cell. When I click the shape for a second time I am looking to return a FALSE value. (I tried a checkbox and they stacked when they were hidden). I can get the TRUE value for one click. However, I am unsure to add in the second click or double click option. Any help is greatly appreciated
Sub Info1_Click()
Application.ScreenUpdating = False
Range("D5").Value = "TRUE"
Application.ScreenUpdating = True
End Sub
Bookmarks