how to bold a string variable

[Pookiemeister]

I'm probably tired or overthinking this, but how can I bold certain words inside a string or the entire string? Thank you

 

[mikerickson]

To bold the characters in a cell you select cell, and in the edit window select the sub text you want bolded and click the B in the home ribbon.
To do this with code

Range("A1").Characters(3,4).Font.Bold = True

will make the 3rd, 4rh, 5th and 6th characters in A1 bold.

Note this will not work if the cell holds a formula. The result of formulas are all in the same font.

 

[Pookiemeister]

My apologies. I should of explained what I was wanting to achieve much better than how I did.

    Dim ctrl As MSForms.Control, cf As MSForms.Control
    Dim s As String
    
    For Each ctrl In Me.Controls
        s = ""
        If TypeName(ctrl) = "Frame" Then
            For Each cf In ctrl.Controls
                If "CheckBoxOptionButton" Like "*" & TypeName(cf) & "*" Then If cf.Value Then s = s & cf.Caption & ", "
            Next
          
            Select Case ctrl.Name
                Case Is = "frmTask"
                    If s <> "" Then MsgBox Left(s, Len(s) - 2) & " with " & frmSelectedItem & ";", vbInformation, ctrl.Name
                    If s <> "" Then Cells(lLastRow, "I") = s & "with " & frmSelectedItem & ";"
              
            End Select
        End If
    Next

I am wanting to bold whatever is inside the string "s". How can I do this? Also if you don't mind can you comment the working code given so I can learn from it please and thank you.

 

[mikerickson]

Userform controls do not take rich text. That is, all the characters in any userform control will have the same font.
One cannot bold part of a TextBox.Text or CheckBox.Caption.