Question

关于excel的问题，想问下VBA代码应该怎么写？

利用写VBA的方式，指定B1储存格和C2储存格内容分别为【O】和【X】， 将B1储存格设定粗体/新细明体/16号字大小，C2储存格设定标楷体/14号字大小/加底线

Answer 1

Range("B1").Select
Range("B1").Value="O"
With Selection.Font
.Name = "新明细体"
.FontStyle = "加粗"
.Size = 16
End With
Range("C2").Select
Range("C2").Value="X"
With Selection.Font
.Name = "楷体"
.FontStyle = "常规"
.Size = 14
End With