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

S

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.
 
C

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
 
S

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?
 
S

Sophie

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