textBox font colour the same as cell font colour????????

[Sophie]

Please can anybody help!!!!

How do I copy the font colour of a cell to a textbox.
Say, cell "A1" font colour changed to RED, then the textbox that is linked
to that cell changes as well.

 

[CurlyDave]

This will not work if the cell color is changed using Conditional
Formating,
Place this code in the Worksheet Module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
TextBox1.BackColor = Range("A1").Interior.Color
End Sub

 

[Sophie]

Thanks Curly,
Unfortunately that is what I was looking for. My cells change colour by
using conditional formating.
I take it there isn't a way then?

 

[CurlyDave]

Probably not, VBA would be needed to color the cells and textBox
conditionally

 

[Sophie]

Thank you Curly. I'll have to dig out a conditional vb code to do this!!!!!
some how!!!