Hi
I am looking to insert a textbox that has characters of nonuniform color. I hope those red and blue"o"s clarified the task at hand.
I have found three web sites that seem to pose a solution:
1. Using a standard textbox: vba changing the color of some of the text in a textbox;
2. Using a richtextbox: http://www.vbforums.com/showthread.php?666655-changing-a-color-for-specific-string-in-text-box; and
3. Another I don't know where to start with:http://stackoverflow.com/questions/...er-in-textbox-in-different-color-in-vba-excel.
I would prefer to use the standard textbox code because I already have code that works with it (you maybe have already guessed that I am new to VBA, but this point must confirm it). That code inserts, names, changes the background and line color of, and populates with text, a textbox. But I am at a loss as to how to use the standard textbox code to heterogeneously color its text. And indeed I have seen enough posters declaring it impossible to shake my confidence.
I was hoping that one fine forum member might help me out here.. Let me know if my question is unclear and I will do my best to refine it.
Any advice would be much appreciated.
i_excel
I am looking to insert a textbox that has characters of nonuniform color. I hope those red and blue"o"s clarified the task at hand.
I have found three web sites that seem to pose a solution:
1. Using a standard textbox: vba changing the color of some of the text in a textbox;
2. Using a richtextbox: http://www.vbforums.com/showthread.php?666655-changing-a-color-for-specific-string-in-text-box; and
3. Another I don't know where to start with:http://stackoverflow.com/questions/...er-in-textbox-in-different-color-in-vba-excel.
I would prefer to use the standard textbox code because I already have code that works with it (you maybe have already guessed that I am new to VBA, but this point must confirm it). That code inserts, names, changes the background and line color of, and populates with text, a textbox. But I am at a loss as to how to use the standard textbox code to heterogeneously color its text. And indeed I have seen enough posters declaring it impossible to shake my confidence.
I was hoping that one fine forum member might help me out here.. Let me know if my question is unclear and I will do my best to refine it.
Any advice would be much appreciated.
i_excel
Last edited: