how to connect user form text box color formatting to cell formatting in excel VBA that I have already formatted

[Tifa]

how to connect user form text box color formatting to cell formatting in excel VBA that I have already formatted

when I use this

Me.Tb_Acc.BackColor = Range("E2").Interior.Color

it shows only the fill color of the cell but the color changes according to the formatting the Text box color stays as it is

 

[Tifa]

Any help!!

 

[Tifa]

Hello!!

 

[mikerickson]

When that line runs the color of the text box will be changed and won't change again until a similar line runs.
Changing a cell's color does not trigger any events, so you cannot automatically have a textbox follow a cells back color.

 

[Tifa]

The problem is it follows only the color fill and not the conditional formatting colors

what is the code needed to make a text box color be similar to the conditional formating colors of the cell

how could I achieve that? what is the code please?

 

[mikerickson]

For a one time matching, you could look at the DisplayFormat property of the cell

Me.Tb_Acc.BackColor = Range("E2").DisplayFormat.Interior.Color

 

[Tifa]

For a one time matching, you could look at the DisplayFormat property of the cell

Me.Tb_Acc.BackColor = Range("E2").DisplayFormat.Interior.Color

Thanks a lot that worked