Formatting cell comments in VB

G

Guest

Hello, I am trying to add a comment to a cell via the following code.
Everything works except the lines that I have commented out. Could someone
steer me in the right direction. Thanks, Brett



Workbooks(wintools).Sheets("Accounts").Cells(pasterow, 11).AddComment
Workbooks(wintools).Sheets("Accounts").Cells(pasterow, 11).Comment.Visible =
False
Workbooks(wintools).Sheets("Accounts").Cells(pasterow, 11).Comment.Text
Text:="CHECK RATE"
Workbooks(wintools).Sheets("Accounts").Cells(pasterow, 11).Select
With Selection.Comment
.Shape.Width = 85
.Shape.Height = 20
' .Shape.HorizontalAlignment = xlCenter
' .Shape.VerticalAlignment = xlCenter
' .Font.Size = 12
' .Font.Bold = True
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comments 2
Auto-Insert & Delete Comments 1
List all comments in a workbook, by sheet and cell 2
Exporting Logo from Access 97 to Excel 2000 by copy and pastespecial is stopping Cell A1 selection 3
Re: Problem with create Excel graph in c# 3

Top