`

VB set Excel color

阅读更多

Sub Macro3()
'
' Macro3 Macro
'

'
    Range("E4").Select
    With Selection.Font
        .Name = "simsun"
        .FontStyle = "标准"
        .Size = 11
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ColorIndex = 26
    End With
   
    Cells.Font.Color = vbRed
    Cells.Font.Color = vbBlack
    Cells.Font.Color = vbBlue
End Sub

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics