how to set the font color in a message box?

[novice_2010]

Hello, all

Suppose i have following codes:

Sub Test()
Dim Color As String
Color = "red"
MsgBox ("The color is " & Color)
End Sub

I want the message box will show like following:

The color is red

What code can make this possible?

 

[Oaktree]

You can't change the font color in a standard msgbox.

You could, however, either create a custom userform or use the ktMsgBoxAddIn that was on Colo's page a while ago (I think it's at http://www.h3.dion.ne.jp/~sakatsu/ktMsgBox_Series_English.htm now).

 

[novice_2010]

Thank you for help.