Hi,
I have some simple code below that generates a cell comment based on the values in six cells.
I would like to have the text in the 1st, 3rd and 5th lines in the comment box to be 'bold'. The number of characters in the cells is completely variable.
How would I add to the code below to achieve this? Many thanks.
I have some simple code below that generates a cell comment based on the values in six cells.
I would like to have the text in the 1st, 3rd and 5th lines in the comment box to be 'bold'. The number of characters in the cells is completely variable.
How would I add to the code below to achieve this? Many thanks.
VBA Code:
Sheet12.Select
Range("D7").Comment.Text Text:=Range("E6") & Chr(10) & Range("E7") & Chr(10) & Range("E8") & Chr(10) & Range("E9") & Chr(10) & Range("E10") & Chr(10) & Range("E11")
Range("D7").Comment.Shape.TextFrame.AutoSize = True
Range("D7").Select