Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Show comment on click ONLY (Excel 2000 >)

    I was cornered by a question this morning on support. The Q was: Can a comment only popup when the cell is selected. They do not want the comment popup if the mouse moves over the cell. (For what reason...I do not know!!)

    I answered NO, unless you try to intercept the mouse move action and attach it to the SheetSelect event.

    Was my answer correct and is this indeed possible?

    Tx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show comment on click ONLY (Excel 2000 >)

    As far as I know, you can't suppress displaying the comment when the mouse passes over the cell.

    Excel has neither a MouseMove event, nor a SheetSelect event.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Show comment on click ONLY (Excel 2000 >)

    <<<Excel has neither a MouseMove event, nor a SheetSelect event.>>>

    Sorry, I meant SelectionChange <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    And MouseMove is a valid event...but not on a sheet though! Probably on a chart or object. I understand the context of your statement though.

    Tx for the reply
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show comment on click ONLY (Excel 2000 >)

    MouseMove is an event for chart sheets (and with a bit of work, for embedded charts), but not for a worksheet, so it won't help to hide cell comments.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Show comment on click ONLY (Excel 2000 >)

    I'm glad that my original answer of "NO" stands firm. (I feel better now that my advice is correct!)

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> for the confirmation on this!
    Regards,
    Rudi

  6. #6
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show comment on click ONLY (Excel 2000 >)

    Here's an odd caveat....

    If one turns off the Application.DisplayCommentIndicator (setting it to xlNoIndicator), the comment does not appear when I scroll over the cell. The slight problem is that one doesn't know if one is passing over a commented cell unless the short (right mouse) menu is checked....

    If a user went to the trouble of modifying a cell that contains comments, hid the comment indicator, and added code to the SelectionChange event, I suppose someone could give a user this functionality.

    I assume the same scenario holds true for 2002 and 2003?

    -Mike

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show comment on click ONLY (Excel 2000 >)

    As far as I know, Excel 2000, 2002, and 2003 treat comments the same way.

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Show comment on click ONLY (Excel 2000 >)

    Mike, your reply triggered a thought. And after testing it, it is working well. It seems that showing a comment only on the clicking (selecting) of a cell IS POSSIBLE by use of the Validation Features Input Message.

    Select the cell, choose Data - Validation.
    Ignore the Validation tab...ensure that it remains on Any Value.
    Select the Input Message tab and type the appropriate comment.
    Choose OK

    Result:
    No comment shows until you select the cell.

    PS: Hans, it seems we got so focussed on "Comments" that we overlooked the Input Message option of Validation. Tx though for all your input too!
    Regards,
    Rudi

Posting Permissions

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