Comments: their positioning when activated

  • Thread starter Thread starter Ian Jones
  • Start date Start date
I

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
 
AFAIK, no one has discovered a way to change the default popup position
of the comment.
 
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
 
Back
Top