title: Auto size row height to match expandable textbox
body: <p>I have inserted a textbox into a row range. The purpose of the textbox is to allow for more dynamic formating of input text than is available by just entering text into a cell.  I would like the textbox to be expandable, which is easily done in the text box settings, and have the corresponding row expand along with it which is not so easy.  I have cells with data below the text box and when it expands now it covers those cells.</p>
  
  <p>I would appreciate any assistence with vba code that would allow the row height to automatically adjust as the text box height adjusts.  I have searched online and while I found 1 similar question but the answer given suggested using a user form textbox that feeds to a cell but that does not meet my formatting needs.  Also just to be clear, this is the text box that is found from the insert menu in Excel.  </p>
  
  <p>I imagine the code would look something like:</p>
  
  <pre><code>On change event (linked to textbox #)'not sure if this is possible
  dim x as long, commentcell_rng as range
  set commentcell_rng as thisworkbook.sheets("Sheet1").range("A81:N81")
      x = textbox # height 'Not sure how to return textbox height also I don't know if text box height matches cell height unit of measure
  commentcell_rng.entirerow.height = x
  </code></pre>
  
  <p>I am not sure if I am going in the right direction but hope this outlines what I want to happen. </p>