title: VBA - How to Set Cursor in a Specific Position in a Textbox?
body: <p>The title mostly explains what I need. I have a textbox that I continuously examine for data validity using the <code>_keypress</code> procedure. If the user enters <code>(</code> then I auto-fill it for them by typing the closing parenthesis <code>)</code>. The result is <code>()</code> and the cursor is at the end of the textbox. 
  My question is, how can I push the cursor back one step to put it between the two parenthesis? Thanks,</p>
  
  <p>Edit: Test scenario:</p>
  
  <pre><code>Private Sub txtInput_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
  
      If KeyAscii = Asc("(") Then
          txtInput.value = txtInput.value &amp; "()"
          KeyAscii = 0
      End If
  
  End Sub
  </code></pre>
  
  <p>Hope this makes it more clear,</p>