displaying comments

T

tjtjjtjt

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
 
X

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
 
X

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
 
D

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

:
Click to expand...
 
T

tjtjjtjt

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

Debra Dalgleish said:
It may not affect you, but Comments will sort with the cell, and Data
Validation input messages won't.
Click to expand...
 
D

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.
 
D

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
'======================
 
T

tjtjjtjt

Thank you!

tj

Debra Dalgleish said:
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
'======================
Click to expand...
 
Top