title: VBA text box font color
body: <p>I'm helping update Excel templates at my work and I need some help. 
  I'm trying to format text in a textbox to be red and remove the border. I'm not sure how to add that property to my code. I'm not very good at coding. I was able to put the below together from dissecting other code I found. </p>
  
  <pre><code>ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 2525, 1800, 103, 24).TextFrame.Characters.Text = Format(Cells(9, 2), "mmmm d, yyyy")
  </code></pre>
  
  <p>I'll eventually replace the absolute location values in the textbox code but I want it to work before I start making efficiency tweaks. Thanks for helping!</p>
  
  <p>EDIT1: The below code works if I use either line 1 and 2 or Line 1 and 3. I'm not sure why I cannot use both in conjuction. </p>
  
  <pre><code>ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 2525, 1800, 103, 24) _
  .TextFrame.Characters.Font.Color = vbRed _
  .TextFrame.Characters.Text = Format(Cells(9, 2), "mmmm d, yyyy")
  </code></pre>