AFAIK you cannot format the text in a message box using VBA. Suggest you
create a custom userform to simulate the msgbox and add a function to
control it.

I recall that John Walkenbach refers to this approach but could not find the
reference on his site, have a look here ...
http://j-walk.com/ss/excel/index.htm

--
Cheers
Nigel



"davidm" wrote in
message ...

Can someone get this to work: Text is supposed to be formatted *Max*imum
value required with only "Max" bolded.

Sub FormatText()
msg = "Maximum value required"
txt = msg.Characters(Start:=1,Length:=3).Font.Bold
Msgbox txt
End sub

TIA


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=379982