title: Advanced text editing for VBA (excel) textbox
body: <p><strong>Preamble</strong></p>
  
  <p>Recently I've been struggling with big excel spreadsheets that have a lot of text and comments (multiple people work on single document). It is tremendously hard to  edit it again and again (considering new notes), since document navigating becomes pretty complicated at some point. So, I decided that I need some tool to get/set only the data I actually need at one moment (single cell content, corresponsive comment content, additional data for the cell's row on demand).</p>
  
  <p><strong>What is done so far</strong></p>
  
  <p>Fortunatelly the start was pretty easy. I filled UserForm with 4 textboxes (2 readonly, 2 for editing), that are filled with data of the selected comment (by index), and some buttons that allow to accept/discard changes and navigate between commented cells.</p>
  
  <p><strong>Questions itself</strong></p>
  
  <p>First of all, I need to keep text formatting when I take the text from cell. Currently I am not taking any formatting, just text. All I found by googling is that I can set formatting character by character, sort of like in the following pseudocode:</p>
  
  <pre><code>For i = 0 to Cells(Row, Col).Text.Length
      MyTextBox.Text(i).FormatOption1 = Cells(Row, Col).Text(i).FormatOption1
      ...
      MyTextBox.Text(i).FormatOptionN = Cells(Row, Col).Text(i).FormatOptionN
  Next
  </code></pre>
  
  <p>But this approach feels to be stupid. So, question one is:</p>
  
  <p><em>Is there a way to copy full text formatting (Font, B/I/U, color, Size for each letter in the cell) alongside with text, from cell to TextBox and backwards, with one line of code?</em></p>
  
  <p>Second of all I actually need some formatting tools in the UserForm to do aforesaid text formatting in my form, so question two is:</p>
  
  <p><em>Is there a way to add formatting tools (the ones that are located in Home->Font menu, or popup menu when you select some text in a cell) into UserForm to edit text in TextBox object?</em></p>
  
  <p>P.S. using Excel 2013</p>
  
  <p>A bit of addition:
  I somehow assume that if there is no direct way to do what I've described in questions - there has to be some custom-made toolbox object (sort of EvenRicherTextBox) that was created by someone before. I just cannot believe that issue never came up, but I have no idea what keywords I need to use in order to find that object.</p>