I want to change the text color of several words in a msgbox text
What's the trick?

*-_Thank-you!_-

--
brucem
-----------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...fo&userid=3287
View this thread: http://www.excelforum.com/showthread.php?threadid=55056

Hi Bruce,

I want to change the text color of several words in a msgbox text

This is not possible using VBA.

What's the trick?

Design a custom msgbox using a userform.


---
Regards,
Norman


"brucemc" wrote in
message ...

I want to change the text color of several words in a msgbox text.
What's the trick?

*-_Thank-you!_-*


--
brucemc
------------------------------------------------------------------------
brucemc's Profile:
http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=550565

Not possible. However, you can change the color of all of the text,
in a message box using a Windows setting. A lot of other text
gets changed along with it.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"brucemc"

wrote in message I want to change the text color of several words in a msgbox text.
What's the trick?
*-_Thank-you!_-*
--
brucemc

Hmmmmm. Really thought there would be something akin to the html tags i
html that could. I know in a line item in the formula bar I could inser
something like [red] and it would change subsequent over to the color
but it has been a real long time since doing so, so even if it woul
work I probably won't recall the correct syntax. Anyway, if all els
fails, I suspect the good old write-up-my-own-darned-msgbox-form metho
will work!

Thank-you, all, for your input. Hope to return the favor someday

--
brucem
-----------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...fo&userid=3287
View this thread: http://www.excelforum.com/showthread.php?threadid=55056