title: Trying to use a shape button to toggle in VBA to hide or expose a comment
body: <p>However, I don't want to use the ActiveXcontrol button.</p>
  
  <pre><code>Sub togglingashape()
  ' I recorded a macro to give me the target shape
  ' Active.Shapes.Range(Array("Flowchart: Alternate Process 1"))
  ' to use in condition below :
  
  If Active.Shapes.Range(Array("Flowchart: Alternate Process 1")).Value = True Then
  
      Range("D3").Comment.Visible = True
  
  Else
      Range("D3").Comment.Visible = False
  
      End If
  
  End Sub
  </code></pre>
  
  <p>Can anyone help?</p>