Get best color match for font in a textbox that switches background color - vba

[kelly mort]

Hi,

I have TextBox1 where I am using vba to switch background color based on contents that appear in it. I currently have one color for the fonts.

One issue is that the color is not visible on some of the background.

I have used various font colors and having same issue.

My only option here is to manually set the font color to match the various background using the same condition I used to switch the background colors.

Before I do so, is it possible to get the best color blend for the stated situation above?

I mean a vba code to determine which color will be visible on a background?

Thanks

 

[mole999]

I would think the best contrast is by using the 56 colour palette and a colour wheel, this might help for limiting choices > Color Palette and the 56 Excel ColorIndex Colors,, and a small freeware program colorpix. If you can limit the input then the output should be easy to set

 

[mole999]

I found this
.ColorIndex = xlColorIndex.xlColorIndexAutomatic
from > Excel Formatting - Format Cells Dialog Box

 

[kelly mort]

I don't understand the line you posted. Should I place that alone in the textbox?

I found this
.ColorIndex = xlColorIndex.xlColorIndexAutomatic
from > Excel Formatting - Format Cells Dialog Box

 

[mole999]

I don't understand the line you posted. Should I place that alone in the textbox?

I think .ColorIndex = .xlColorIndexAutomatic should be in the font section of your cell selection,

something is nagging me about textboxes, not something I have used for a long time

 

[kelly mort]

I will use the conditions to set the colors as I have said before.

Thanks