title: How do you format text/strings in VBA?
body: <p>In the code below, I take some input parameters, either text or a cell, and combine them to form one string using the formatting I need.  I need to make Task_Name bold, as well as text like "Lead :".  I know you cannot make text in a variable bold, but how do I go about this?  This cell I'm storing the value in is eventually used in a Word mail merge.</p>
  
  <p>I need to format part of a string.  In the code below, I need to make Task_Name, "Lead : ", etc. all bold.</p>
  
  <pre><code>Function GENERATE_STAFFING_SECTION(Task_Name, Lead_By, Members, Instructions)
      Dim tmpSection As String
  
      If Len(Task_Name &gt; 0) And Len(Lead_By) &gt; 0 And Len(Members) &gt; 0 And Len(Instructions) &gt; 0 Then
          tmpSection = vbLf _
                      &amp; Task_Name _
                      &amp; vbLf &amp; "Lead : " &amp; Lead_By _
                      &amp; vbLf &amp; "Ambassadors : " &amp; Members _
                      &amp; vbLf &amp; "Instructions : " &amp; Instructions _
                      &amp; vbLf
      Else
          tmpSection = ""
      End If
  
      GENERATE_STAFFING_SECTION = tmpSection
  End Function
  </code></pre>
  
  <p>Also, I know it's not the cleanest code, so if there are any other suggestions for improving it, they are most welcome.</p>
  
  <p>Thanks!</p>