Change Textbox Backcolor (multiple textboxes)

Hi,

I have 5 textboxes on a userform. I would like to be able to change the backcolor of all of them to be the same if one changes.

I will try to explain this a little better

The backcolor of each of the 5 textboxes can change if the value meets a criteria:

If value less than 2 textbox is green (good - lowest score)
If value between 3 and 4 textbox is orange (ok)
If value is over 4 textbox is red.(bad - highest score)

This is applied to each textbox individually and works fine. So I could have one red box, two orange and two green.

What I would like to happen is this:

If any of the boxes are red - all boxes need to go red.
If there are no red boxes and one of the boxes is orange - all boxes need to go orange.


Does anyone know if this is possible?

If any of the boxes are red - all boxes need to go red.
If there are no red boxes and one of the boxes is orange - all boxes need to go orange.

What if the textboxes contain conflicting values, which one gets priority and decides the color to use?

Since you didn't provide a workbook example, perhaps you can build off of the following.
Assuming Textbox1 is used for inputting the value, then the other check boxes will change color per the value.

Note: this is basic code - there are no checks for valid entries into Textbox1.

Please Login or Register  to view this content.