title: Custom Design of an Excel Textbox VBA
body: <p>Well I was wondering whether we can somehow create custom looking text boxes that act as an input box and is linked to VBA.</p>
  
  <p>As far as I am aware the standard procedure would entail adding an ActiveX Textbox Control and then using the <code>TextBox1_Change</code> event to add the code as to what needs to happen when the user enters something in to.</p>
  
  <p>Sadly the look of the default textbox isn't matching the way I want by spreadsheet to look. So is there any way to change how it looks or have something replace it while serving the same purpose?</p>
  
  <p>One thing I could think of and have tried is inserting a shape (blue):</p>
  
  <p><a href="http://im52.gulfup.com/qD2F0B.png" rel="nofollow noreferrer">Shape http://im52.gulfup.com/qD2F0B.png</a></p>
  
  <p>I can get the text that is in the shape using VBA by:</p>
  
  <pre><code>InputText = Shapes("Rounded Rectangle 1").TextFrame.Characters.Text
  </code></pre>
  
  <p>But I don't suppose there is a way to detect a change of shape text event?</p>
  
  <p>Suggestions / Workarounds are welcome!</p>
  
  <p>Thanks</p>