Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comments (Excel 2000)

    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?

  2. #2
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000)

    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)

    <font face="Georgia">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</font face=georgia>

    Errol

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Comments (Excel 2000)

    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
    [MS MVP - Word]

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000)

    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?

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000)

    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

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000)

    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

  7. #7
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000)

    Thanks for the help! It works great!

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Comments (Excel 2000)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •