作者h02158 ()
看板Office
标题[问题] VBA注解指定粗体字型
时间Fri Oct 4 14:21:25 2019
软体: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://webptt.com/cn.aspx?n=bbs/Office/M.1570170087.A.2D4.html
※ 编辑: h02158 (42.72.95.27 台湾), 10/04/2019 14:44:49
1F:→ soyoso: 内文的font.bold改以...shape.textframe.characters来改 10/04 14:48
2F:→ soyoso: 第一行变粗体字,开始1,长度就instr找chr(10)的位置,後 10/04 14:49
3F:→ soyoso: 面一样font.bold =true 10/04 14:49