title: Open InputBox based on Checkbox
body: <p>I'm not proficient with Excel VBA so, apologies if this sounds like an obvious question to be asked...<br>
  I'm building a model in Excel, and I'm actually trying to trigger an <code>inputbox</code> if a <code>checkbox</code> is checked.</p>
  
  <p>So far I managed to do the following: </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      Set Target = Range("G7")
  
      If Target.Value = "TRUE" Then
  
          Dim QtyEntry As Integer
          Dim Msg As String
          Msg = "Please insert value"
          QtyEntry = InputBox(Msg)
          ActiveSheet.Range("C7").Value = QtyEntry / 100
  
      End If
  End Sub
  </code></pre>
  
  <p>The <code>target.value</code> <code>G7</code> is the cell linked to the <code>checkbox</code>, so it returns <code>TRUE</code> when the check is on or <code>FALSE</code> when the check is off. 
  However, I've two kind of problems. The first one is that the Macro doesn't actually activate when I check the checkbox (but it does if I write "TRUE" in the target cell. </p>
  
  <p>The second is that when the <code>inputbox</code> appears, it correctly places the value in cell <code>C7</code>, but then it  it keeps on asking to input values without disappearing. </p>