You can do this with formatting. For example, the following code will
change all comments to Verdana, font size 12:

'======================
Sub FormatAllComments()
Dim ws As Worksheet
Dim cmt As Comment
For Each ws In ActiveWorkbook.Worksheets
For Each cmt In ws.Comments
With cmt.Shape.TextFrame.Characters.Font
.Name = "Verdana"
.Size = 12
End With
Next cmt
Next ws
End Sub
'========================


steve wrote:
Is it possible to format the font of the comments in various cells in a
particular sheet at once.Isit possible to change the taqhoma font to verdana
in the comment boxes all at once


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html