ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change color of text segment in msgbox (https://www.excelbanter.com/excel-programming/363869-change-color-text-segment-msgbox.html)

brucemc[_12_]

Change color of text segment in msgbox
 

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


Norman Jones

Change color of text segment in msgbox
 
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




Jim Cone

Change color of text segment in msgbox
 
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


brucemc[_13_]

Change color of text segment in msgbox
 

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



All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com