Match TextBox Back Color to Cell Fill Color

[Guest]

Hi,

Cell A1 fill color is Green. It is conditional formatted to turn Red for a
certain value.

Is it possible to code a TextBox Back Color on a VBA Form to turn Red also
if Cell A1 is Red?

I looked in the archives for this, but didn't find quite what I'm looking for.

Thank you for your time in reading my question.
Amy

 

[Guest]

Do you want this to happen when the form opens? When the value changes?

In any case you'll need something similar to the following:
If Range("A1").interior.colorindex = 3 then
textbox1.backcolor = &HFF&
end if

 

[Guest]

Thanks for answering my question JNW. This can happen when the form opens.
It does not have to change immediately after the value changes.
Would you insert the code under the Form1 Open procedure?
Thanks again,
Amy

 

[Guest]

Double-click on the for in VBA and put the code under the UserForm_Initialize
procedure.

 

[Guest]

Thanks JNW it works!
Amy

Double-click on the for in VBA and put the code under the UserForm_Initialize
procedure.