Hi,
I've got following VBA code in in addition I want the text to be centered, underlined and the font color RED.
Could please omebody help me out.
Many thanks in advance
<tbody>
</tbody><colgroup><col><col></colgroup>
I've got following VBA code in in addition I want the text to be centered, underlined and the font color RED.
Could please omebody help me out.
Many thanks in advance
Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Target, Range("A1:A10")) _ Is Nothing) Then With Target If Not .HasFormula Then Application.EnableEvents = False .Value = UCase(.Value) Application.EnableEvents = True End If End With End If End Sub |
<tbody>
</tbody><colgroup><col><col></colgroup>