Comments (Excel 2000)

Topic

New Reply

It seems that Excel comments will only appear if you select a cell or mouse over it. How can you make comments appear when you TAB into a cell?

Reply | Quote

Replies

Cowboy,
Welcome to Woody’s Lounge!

(At least in Excel 2000) I could find no View option to show comments only when a cell has focus. Here’s a short macro that does that, though. Just set up something to flag the particular cells/range that you need to show comments and put it in where I have “$B$4”. (There’s probably better ways. They’ll show up on this board)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = (“$B$4”) Then
Application.DisplayCommentIndicator = xlCommentAndIndicator
Else
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End If
End Sub

Errol

Reply | Quote

Thanks for the help. This worked, however, it showed the comments in all cells at once. I want to show only the comment for the selected cell. Can I do that?

Reply | Quote

Does this do what you want?

It ran kind of slow on my machine, but I’m working with 30 workbooks open at the time, so maybe that’s my problem. Perhaps it could be written better as well…

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Application.DisplayCommentIndicator = xlCommentIndicatorOnly
On Error GoTo errhandler
If ActiveCell.Comment.Visible = False Then
ActiveCell.Comment.Visible = True
End If

errhandler:
End Sub

Reply | Quote

I got to thinking about it and the IF was actually unnecessary…this should do the same thing with less code. They both do what you wanted, though.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Application.DisplayCommentIndicator = xlCommentIndicatorOnly
On Error Resume Next
ActiveCell.Comment.Visible = True
End Sub

Reply | Quote

Thanks for the help! It works great!

Reply | Quote

Thanks for the help! It works great!

Reply | Quote

Does this do what you want?

It ran kind of slow on my machine, but I’m working with 30 workbooks open at the time, so maybe that’s my problem. Perhaps it could be written better as well…

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Application.DisplayCommentIndicator = xlCommentIndicatorOnly
On Error GoTo errhandler
If ActiveCell.Comment.Visible = False Then
ActiveCell.Comment.Visible = True
End If

errhandler:
End Sub

Reply | Quote

Thanks for the help. This worked, however, it showed the comments in all cells at once. I want to show only the comment for the selected cell. Can I do that?

Reply | Quote

Cowboy,
Welcome to Woody’s Lounge!

(At least in Excel 2000) I could find no View option to show comments only when a cell has focus. Here’s a short macro that does that, though. Just set up something to flag the particular cells/range that you need to show comments and put it in where I have “$B$4”. (There’s probably better ways. They’ll show up on this board)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = (“$B$4”) Then
Application.DisplayCommentIndicator = xlCommentAndIndicator
Else
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End If
End Sub

Errol

Reply | Quote

Hi cowboyfan,

You can also make all comments display on a full-time basis, via Tools|Options|View and checking ‘Comment&indicator’

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Hi cowboyfan,

You can also make all comments display on a full-time basis, via Tools|Options|View and checking ‘Comment&indicator’

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

A way without the macro may be done using datavalidation instead of a comment.

Data – validation -Input message(tab) – add a mesage (and title if desired).

Steve

Reply | Quote

A way without the macro may be done using datavalidation instead of a comment.

Data – validation -Input message(tab) – add a mesage (and title if desired).

Steve

Reply | Quote