comment box flags VBA

[Jack in the UK]

Hi guys tought one..

i can command excel to change the default comment box to what ever picture or shape i want, but can i also add lines of code to change the triangle flag top right to say 3 times its size ???

is is possible to change the coloyur to say blue or black also???

any ideas guys... mush love to do this...

 

[Jack in the UK]

Hi Guys spent a day playing on this one, any ideas or pointers??

Would be good thou:
And would hlep me a lot.... thanks again.

 

[Jay Petrulis]

Hi Jack,

Posted by Dave Peterson and Dana DeLouis in microsoft.excel.programming

http://groups.google.com/groups?hl=en&selm=3C7ABF50.5A72208D@msn.com

------------------------
Sub testme()

Dim mycell As Range
Dim myRng As Range
Dim lArea As Long

Set myRng = Selection

For Each mycell In myRng.Cells
If Not (mycell.Comment Is Nothing) Then
With mycell.Comment
.Shape.TextFrame.AutoSize = True
If .Shape.Width > 300 Then
lArea = .Shape.Width * .Shape.Height
.Shape.Width = 200
.Shape.Height = (lArea / 200) * 1.2
End If
End With
End If
Next mycell

End Sub
------------------------

You should be able tomanipulate the settings as you want.

HTH,
Jay

 

[Jack in the UK]

Hi Jay --

Im impressed thanks for the effort i never know that site was there i stick onthis on eonly.. good info over there..

cheers again good start...