| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments with text from cells
I am using the below code to create comments. Does anyone know if it can
be modified so that the comments contain text from a given cell? ActiveCell.AddComment ActiveCell.Comment.Text Text:="" ActiveCell.Comment.Visible = True With ActiveCell.Comment.Shape.OLEFormat.Object .Font.Name = "Arial" .Font.Size = 20 .Font.Bold = True .Width = 400 .Height = 300 End With End Sub coco  ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| building comments from text cells | Excel Worksheet Functions | |||
| Text Box Comments | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| Text disappearing from cells and comments? | Excel Discussion (Misc queries) | |||
| Add Comments with Text From Cells | Excel Programming | |||
Threaded Mode
