Positioning a comment help?

Hi,
I am on Excel 2011 and I have to put a picture in a comment and have sorted everything except positioning it!
Every time I drag it into the position I was it to pop up into, and then test it, it always goes into the default position which is not where I want it. But I cannot get it to pop up into the position I want it to!
Can anybody help me? Or point out anything I may be doing wrong?
Thanks

This might help. It will make a comment appear in a defined position when a single cell is selected.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo NoComment
PreviousTargetAddress = Cells(Rows.Count, Columns.Count).Value
If PreviousTargetAddress <> "" Then
    Range(PreviousTargetAddress).Comment.Visible = False
End If
MyCoordinates = Split(Target.Comment.Text, ",")
Target.Comment.Shape.Left = MyCoordinates(0)
Target.Comment.Shape.Top = MyCoordinates(1)
Target.Comment.Visible = True
Cells(Rows.Count, Columns.Count) = Target.Address
Exit Sub
NoComment:
End Sub

For this to work, the above code needs to be pasted into the appropriate sheet tab (e.g. Sheet1) in the VBA editor. Additionally, the text in the comment needs to specify the coordinates (e.g. 39.75,333) separated by a comma, The font can be sort of hidden by use of a suitably small font and appropriate colour.

Originally Posted by mrice

This might help. It will make a comment appear in a defined position when a single cell is selected.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo NoComment
PreviousTargetAddress = Cells(Rows.Count, Columns.Count).Value
If PreviousTargetAddress <> "" Then
    Range(PreviousTargetAddress).Comment.Visible = False
End If
MyCoordinates = Split(Target.Comment.Text, ",")
Target.Comment.Shape.Left = MyCoordinates(0)
Target.Comment.Shape.Top = MyCoordinates(1)
Target.Comment.Visible = True
Cells(Rows.Count, Columns.Count) = Target.Address
Exit Sub
NoComment:
End Sub

For this to work, the above code needs to be pasted into the appropriate sheet tab (e.g. Sheet1) in the VBA editor. Additionally, the text in the comment needs to specify the coordinates (e.g. 39.75,333) separated by a comma, The font can be sort of hidden by use of a suitably small font and appropriate colour.

Thanks alot! I shall try it out asap!