Cell Comments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to show a comment only when the corresponding cell is selected?
 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim C As Comment

For Each C In ActiveSheet.Comments
C.Visible = (C.Parent.Address = Target.Address)
Next C

End Sub
 
Not a comment I don't believe (I assume you are unhappy with the default
behavior), but perhaps you could use data validation. It has several
options for popping up messages.

--
Regards,
Tom Ogilvy

LDanix said:
Is there a way to show a comment only when the corresponding cell is
Click to expand...
selected?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add comments to selected cells within a selected range 30
If ActiveCell has a comment then exit sub 22
Excel Import Comments 3
Copying a Picture From Cell Comment 0
Control of cell comments lsot in Office10 1
Inserting Comments - 2nd post 2
Comments Boxes 6
Copy to a mid column range Row 10 - Row 20 4

Back
Top