[問題] VBA註解指定粗體字型
軟體:Excel
版本:2016
我想在註解的第一行變粗體字，語法如下
Sub COMM()
Set c = Selection
i = 1
For i = 1 To c.Worksheet.Comments.Count
c.Worksheet.Comments(i).Shape.DrawingObject.ShapeRange.Height = 110
c.Worksheet.Comments(i).Shape.DrawingObject.ShapeRange.Width = 200
c.Worksheet.Comments(i).Shape.DrawingObject.Font.Name = "Tahoma"
c.Worksheet.Comments(i).Shape.DrawingObject.Font.Size = 10
c.Worksheet.Comments(i).Shape.DrawingObject.Font.FontStyle = "標準"
c.Worksheet.Comments(i).Shape.DrawingObject.Font.Bold = True
Next i
End Sub
要如何把<b>This text is bold</b>加入到語法裡面？
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 42.72.95.27 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1570170087.A.2D4.html
※ 編輯: h02158 (42.72.95.27 臺灣), 10/04/2019 14:44:49
→
10/04 14:48,
6年前
, 1F
10/04 14:48, 1F
→
10/04 14:49,
6年前
, 2F
10/04 14:49, 2F
→
10/04 14:49,
6年前
, 3F
10/04 14:49, 3F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
11
22