Format message box

[josros60]

Hi,

is there anyway to format the message box like bold and colour(attached picture of msg box):

here is the code:

'Add code in Sheet module
'Declaring variables
Dim intCounter As Integer
Dim txt As String

'Checking that target column should not be greater than 5
If Target.Column > 11 Then Exit Sub

Cancel = True

'Getting values of target row in string
For intCounter = 1 To 11
   txt = txt & Cells(Target.Row, intCounter) & vbLf
Next intCounter

'Displaying string message
MsgBox txt

End Sub

Thank you

 

[Jimmypop]

I do not think that MsgBox supports Bold Font or color change... (I might be wrong) you would be better off using a custom userform.

Getting bold font for a Msgbox might be possible but this could require API Calls and serious coding skills lol...

 

[Dan_W]

I think you may have attached the wrong image.
In any event, as @Jimmypop points out, it is doable and does require API calls... but you're in luck, because one of the forum experts has recently created code (and a workbook demonstrating how to use the code) that generates colourful, custom messageboxes: Multi-Color VBA MsgBox Including Buttons ( Easy to use )

 

[Jimmypop]

I think you may have attached the wrong image.
In any event, as @Jimmypop points out, it is doable and does require API calls... but you're in luck, because one of the forum experts has recently created code (and a workbook demonstrating how to use the code) that generates colourful, custom messageboxes: Multi-Color VBA MsgBox Including Buttons ( Easy to use )

Hi Dan_W

Thanks for the link. Will go have a look one time...