Results 1 to 14 of 14
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    insert comment in a cell... (2000 sr 1)

    ... i know how to insert a comment in a cell, and when the cursor go here the comment is show.
    But is possible to show the comment when i postion me in the cell to use the tab key or move curson with the arrow on the keyboard? show the comment for few second naturally...

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

    Re: insert comment in a cell... (2000 sr 1)

    I don't think that would be a good idea. If the user moved around rapidly in a worksheet with lots of comments, it would become very busy with comments flashing on and off. Better set your preference in the View tab of Tools | Options... You can choose to always display comments, or just comment markers, or nothing.

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

    Re: insert comment in a cell... (2000 sr 1)

    This is never-the-less an interesting question. If we were to go about this, how can a person test if the cell has a comment.
    ie:
    If activecell.comment then
    activecell.comment.visible = true
    else
    activecell.comment.visible = false
    end if

    This is obviously not the right code, but how do you test if a cell has a comment?
    Regards,
    Rudi

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: insert comment in a cell... (2000 sr 1)

    Hummmm...
    I tink another way...
    Tks.

    Have you like the gift trophy?

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

    Re: insert comment in a cell... (2000 sr 1)

    Yes, thank you! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

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

    Re: insert comment in a cell... (2000 sr 1)

    You could test like this:

    If Not ActiveCell.Comment Is Nothing Then
    ...
    End If

  7. #7
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: insert comment in a cell... (2000 sr 1)

    Hans,

    How about doing it with a data validation? Just set it to Allow any value and type the comment in the Input Message box, checking the box Show when cell is selected.
    Just a thought.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

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

    Re: insert comment in a cell... (2000 sr 1)

    Good idea! I tend to forget that you don't have to specify anything specific in the first tab.

  9. #9
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: insert comment in a cell... (2000 sr 1)

    Thanks!
    I take that as a High Compliment. Depending on what he is trying to do, he could use the macro code I got from Debra Dalgleish (for DataValInputMsgAlt.xls). It shows the message in a fixed Text box that only appears when the cell is active. If you move to another cell, the text box disappears. I do not remember where on this lounge I saw the link to this, but it is slick.
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

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

    Re: insert comment in a cell... (2000 sr 1)

    Thanx Reimer, that is a very good suggestion. No code necessary and its easy to maintain!! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  11. #11
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: insert comment in a cell... (2000 sr 1)

    Hans, referedc the post and refer my post i not have understand well wath is the sugestion of Reimer...
    For example...

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

    Re: insert comment in a cell... (2000 sr 1)

    Instead of inserting a comment in a cell, you can do the following:
    - Select Data | Validation (Dati | Convalida)
    - Activate the second tab.
    - Type a title and a message.
    - Click OK.
    See attached workbook. If you go to cell B2 using the mouse or the keyboard, you will see a message. This is not a comment, but created as described above.

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

    Re: insert comment in a cell... (2000 sr 1)

    Hi Sal,

    Are you querying that you do not understand the suggestion that Reimer gave regarding Data Validation?
    Regards,
    Rudi

  14. #14
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: insert comment in a cell... (2000 sr 1)

    Rudi Hans Tks for help.. but for me in this moment : <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

Posting Permissions

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