| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cell comments in VB
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(paste row, 11).AddComment Workbooks(wintools).Sheets("Accounts").Cells(paste row, 11).Comment.Visible = False Workbooks(wintools).Sheets("Accounts").Cells(paste row, 11).Comment.Text Text:="CHECK RATE" Workbooks(wintools).Sheets("Accounts").Cells(paste row, 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting cell comments in VB
hi
see debra's site. http://www.contextures.com/xlcomments03.html regards FSt1 "Brettjg" wrote: 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(paste row, 11).AddComment Workbooks(wintools).Sheets("Accounts").Cells(paste row, 11).Comment.Visible = False Workbooks(wintools).Sheets("Accounts").Cells(paste row, 11).Comment.Text Text:="CHECK RATE" Workbooks(wintools).Sheets("Accounts").Cells(paste row, 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting for Comments | Excel Worksheet Functions | |||
| Macro for Conditionally Formatting Comments | Excel Worksheet Functions | |||
| formatting comments | Excel Discussion (Misc queries) | |||
| Formatting of Cell Comments with XML-Files | Excel Discussion (Misc queries) | |||
| formatting of comments | Excel Worksheet Functions | |||
Linear Mode
