title: Excel 2010 VBA Prompt and Uncheck on Checkbox Click
body: <p>I have a columns of checkboxes in Excel. When one of them is checked, I want to prompt the user "Are you sure?" or something to that effect. If they answer "Yes", move on and do nothing. If they answer no, I want to uncheck the box (the one they just clicked).
  It seems simple enough, but I can't for some reason get it to work.</p>
  
  <p>I've tried something like:</p>
  
  <pre><code>r = MsgBox("Are you sure", vbYesNo, "Eh?")
  If r &lt;&gt; vbYes Then Application.Undo
  </code></pre>
  
  <p>But that doesn't quite work. It seems so simple, yet it ends up being a pain.</p>