title: If value = true then append 1 else 0 in VBA
body: <p>I'm not sure if this is feasible, but I figured I'd ask and see if anyone had any bright solutions.</p>
  
  <p>I'm creating a VBA form that people will use to assemble an SQL string: "Tick this box to make this parameter true" kind of stuff.</p>
  
  <p>The obvious way to implement this would be</p>
  
  <pre><code>If Checkbox.Value Then
      string = string + "@parameter = 1, "
  Else
      string = string + "@parameter = 0, "
  End If
  </code></pre>
  
  <p>The annoyance is that this is kind of verbose.  It would be nice if I could do something like this:</p>
  
  <pre><code>string = string + "@parameter = " + Checkbox.value + ", "
  </code></pre>
  
  <p>But I'm not sure if that's feasible.  Is it possible?</p>