displaying comments

[Guest]

Is there a way to make Excel display a comment when a cell is selected (as opposed to moving the cursor over the cell)? And, is it possible to make the comment disappear when the cell is deselected?
Thanks,

tj

 

[XLML]

Hi,

Have you tried applying a Validation message to a cell rather than
comment?

This has the effect of only showing a message when the cell i
selected.

To apply:
1)Choose Data-Validation
2)Choose Input Message Tab
3)Check Show Input Message when cell is selected
4)Type message in Input Message Box

After applying Data-Validation to one cell, it can be Copied an
PasteSpecial-Validation to other cells.

Let me know if it works - good luck.
XLM

 

[pikapika13]

Cool XLML! Didn't know that...is there a shortcut key to that

 

[XLML]

The best keyboard shortcut I could come up with opens the Dat
Validation dialog box. You would still have to click on the Inpu
Message tab.

The keys are: Alt + D + L

XLM

 

[Debra Dalgleish]

It may not affect you, but Comments will sort with the cell, and Data
Validation input messages won't.

Wow, that's clever. And to think I just spent a couple of hours carefully laying out some Data Validation, and it didn't occur to me to use it for that. Thanks,

tj

:

 

[Guest]

That doesn't impact my current situation, but it might affect other scenarios. I'm at best a VBA neophyte--does anyone have a method for a sheet event that would evaluate the selected cell to see if it had a comment attached, and display the comment if it does. Then, rehide the comment when a different cell is selected and start the process over for the new cell?
Seems like a lot of work to avoid grabbing the mouse, doesn't it?
Any help any more help would be greatly appreciated.

tj

It may not affect you, but Comments will sort with the cell, and Data
Validation input messages won't.

 

[Dave Peterson]

You could put a button on your favorite toolbar:

Tools|customize|Commands Tab|Data category
drag the "validation..." icon to your favorite toolbar.

 

[Debra Dalgleish]

You could use the SelectionChange event to show or hide the comments:

'===============
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.DisplayCommentIndicator = _
xlCommentIndicatorOnly
If Target.Comment Is Nothing Then
Exit Sub
Else
Target.Comment.Visible = True
End If
End Sub
'======================

 

[Guest]

Thank you!

tj

You could use the SelectionChange event to show or hide the comments:

'===============
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.DisplayCommentIndicator = _
xlCommentIndicatorOnly
If Target.Comment Is Nothing Then
Exit Sub
Else
Target.Comment.Visible = True
End If
End Sub
'======================