Textbox font colour change?
ActiveSheet.TextBox1.ForeColor = 65280
"Tdp" wrote:
I have a textbox linked to a cell in excel, which is already formatted as
"dd-mmm-yy". How can I also include in the texbox font colour to be the same
as in the cell?
I am using the following code to format the textbox:
If IsDate(FoundCell.Offset(0, 1).Value) Then
Me.TextBox1.Value = Format(FoundCell.Offset(0, 1).Value, "dd-mmm-yy")
--
Tdp
|