Kirk,

Try code such as the following:

With Range("E9")
If Not .Comment Is Nothing Then
With .Comment
With .Shape
.Top = Range("E11").Top
.Left = Range("G11").Left
.Height = 100
.Width = 100
End With
.Visible = True
End With
End If
End With

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Sat, 07 Feb 2009 16:23:51 +1300, kirkm wrote:


Is is possible to show a Comment by code instead of mousing over
it ??
If yes, can its display position be changed at all ?

Thanks - Kirk