Toggle Breakpoint (VBE)

  • Thread starter Thread starter VILLABILLA
  • Start date Start date
V

VILLABILLA

Hi,

I have a macro that produces a simpel diagram, when I press the butto
where I assigned this macro to, it appears. I want it to dissapear wit
a second click on the button. When I assign the macro to a check box o
option button it has the same effect as the normal button so it jus
produces a second diagram.
When I was looking around (because more I can't) in the visual basi
editor, I saw the option 'toggle breakpoint'.
My guess is that I would have to use that one, I just wouldn't kno
how... Any other solution to my issue is of course also very welcome.

Thanks in advance!

Robb
 
Robby,

Here is some code to ad/remove a shape

With ActiveSheet
If .CheckBoxes("Check Box 3").Value = xlOff Then
.Shapes("Bob").Delete
Else
.Shapes.AddShape(msoShapeOval, 327#, 169.5, 234#, 85.5).Name =
"Bob"
End If
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top