Specify Size of Comment
Posted by JAF on February 22, 2000 3:29 AM
I have a macro which tracks changes to cells within a worksheet by adding comments to changed cells. . . .
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
here = Target.Address
newnum = Target.Value
oldnum = Sheets("historical data").Range(here).Value
If oldnum = "" Then GoTo line99
oldcomment = Target.Comment.Text
Target.Comment.Text oldcomment & "Modified: " & Date & " " & Time & " by " & Application.UserName & ". Previous value was " & oldnum & Chr(10)
Sheets("historical data").Range(here).Value = newnum
This works nicely, but the only slight problem is that the default comment size is too small.
Is there any way to either change the default size of a comment or to specify the required size when the comment is created?