LearningExcelAgain
New Member
- Joined
- May 25, 2018
- Messages
- 2
I will start by saying that I have successfully gotten a couple of VBA macros to work but I do not know what I am doing...
I have added some combo boxes into a spread sheet. These boxes reference cells in a column that is defined. I can get the selection to work ie. I select Good from the list and it brings it into the list box. The issue that I am having is that I want the text color to follow as well. The words in the list are formatted as follows:
Good (Green)
Bad (Orange)
Ugly (Red)
When I select any of the words it comes across as just black text without the underlying color. Also since the individual selections have a different preferred color setting the format of the box will not do what I want.
any ideas on this?
I have added some combo boxes into a spread sheet. These boxes reference cells in a column that is defined. I can get the selection to work ie. I select Good from the list and it brings it into the list box. The issue that I am having is that I want the text color to follow as well. The words in the list are formatted as follows:
Good (Green)
Bad (Orange)
Ugly (Red)
When I select any of the words it comes across as just black text without the underlying color. Also since the individual selections have a different preferred color setting the format of the box will not do what I want.
any ideas on this?