Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert comment in a cell Excel
Is it possible to define the width and length of the comment in a cell by
Excel programming? Such a button in the Excel sheet, which add a comment in a cell and this comment would have the length and width desired. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert comment in a cell Excel
Experiment with the following:
'---------------------------------------------------------------------- Public Sub TestCommentSize() Dim rngA1 As Range Dim comA1 As Comment Set rngA1 = ActiveSheet.Range("A1") With rngA1 .ClearComments .AddComment "This is a very big, very long comment to test sizing." Set comA1 = .Comment End With With comA1.Shape .Height = 100 .Width = 50 End With End Sub -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can insert digital ink into Excel cell or a cell comment? | Excel Discussion (Misc queries) | |||
in the Excel 2010 Beta, how do I insert a comment on a cell? | Excel Discussion (Misc queries) | |||
Insert comment to Cell | Excel Discussion (Misc queries) | |||
In Excel, can I insert a photo into a comment cell? | Excel Discussion (Misc queries) | |||
How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) |