Mo PTT
Office

[問題] VBA註解指定粗體字型

作者: h02158(原文連結)
軟體: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>加入到語法裡面?

回應

3
soyoso內文的font.bold改以...shape.textframe.characters來改
soyoso第一行變粗體字,開始1,長度就instr找chr(10)的位置,後
soyoso面一樣font.bold =true