Comments: their positioning when activated

[Ian Jones]

Is there a way to "set" a comments position when it is
activated (that is, when "it's" cell position is clicked,
or hovered over with the mouse).

It is possible to specify the way a comment is positioned
by editing and then dragging it to the desired position
but it only "sticks" when selecting show comment rather
than it's "normal" behaviour.

TIA

Ian

 

[Debra Dalgleish]

AFAIK, no one has discovered a way to change the default popup position
of the comment.

 

[Dana DeLouis]

This isn't a solution to the op's problem. Just another idea. Sometimes I
like to throw the comments in a Validation message. This message stays the
same on the screen after it is moved. Here is a small code sample. Again,
not a solution, but maybe a workaround for you.

Sub AddValidationNote(rng As Range, sTitle As String, sMessage As String)
'// = = = = = = = = = = = = = = = =
'// Dana DeLouis
'// Adds a note via Cell Validation
'// Validation messages appear at same spot on screen
'// Title uses Bold font
'// = = = = = = = = = = = = = = = =
With rng.Validation
.Delete
.Add _
Type:=xlValidateInputOnly, _
AlertStyle:=xlValidAlertInformation


.IgnoreBlank = True
.InCellDropdown = True
.ErrorTitle = vbNullString
.ErrorMessage = vbNullString

.ShowInput = True
.ShowError = False

.InputTitle = sTitle
.InputMessage = sMessage
End With
End Sub

Sub TestIt()
AddValidationNote [C1], "Note:", Date & ":" & vbLf & "Here is my note"
AddValidationNote [C100], "Note:", "Here is another note that appears in
the same spot on screen"
End Sub