How to bold a string within a string and variables

Asked Jul 24 '19 at 06:34

Active Jul 24 '19 at 06:37

Viewed 30 times

Code

Below is my Function:

Function InitialHeading(Optional ByVal Accrual As String, Optional ByVal Status As String, Optional ByVal Description As String, Optional ByVal RecipientAccount As String, Optional ByVal RecipientName As String, Optional ByVal AgreeType As String, Optional ByVal DateFrom As String, Optional ByVal DateTo As String) As String

    InitialHeading = "Accrual: " & Accrual & "    Agreement Status: " & Status & "    Date: " & DateFrom & " - " & DateTo & "    Description: " & Description & "    Rebate Recipient Details: Account - " & RecipientAccount & "    Name - " & RecipientName

End Function

Problem

I want all the non variables to be bold. I want variables Accrual & Status font colour red.

Research

I have done multiple sarches but the best I can get is setting the entire string ie. InitialHeading ALL bold or ALL red.

Output

In the below output the variable Status = "Open" and thus the word Open needs to be font = red:

Accrual: 123456 Agreement Status: Open etc etc etc

edited Jul 24 '19 at 06:37

Pᴇʜ

56,719
10
49
73

asked Jul 24 '19 at 06:34

alowflyingpig

2

You cannot format a string in a variable. That is not possible, you can only format it in a cell. – Pᴇʜ Jul 24 '19 at 06:37
Thanks. Guess we can close this question then – alowflyingpig Jul 24 '19 at 06:38
1

@Pᴇʜ thanks for the link. I tried all sorts of searching but never search for that specific search text. This will work nicely. Cheers! – alowflyingpig Jul 24 '19 at 06:42

How to bold a string within a string and variables

0 Answers0