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

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

--
Sophie

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

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

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

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


"CurlyDave" wrote:

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

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

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

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

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


"CurlyDave" wrote:

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