+ Reply to Thread
Results 1 to 9 of 9

comments for drop down list items?

  1. #1
    Registered User
    Join Date
    09-10-2008
    Location
    WV
    Posts
    5

    comments for drop down list items?

    I have a drop down list of people's initials for work orders. Basically the user selects the initials of the person who issued the work order. I'm using a validated list and have the list items stored on a separate sheet. Is there a way to add comments to the initials so if you mouse over it you can see who the person's name is. I.e. You select the initials JS and when you mouse over it it says "John Smith". However, this is a long column of listings, so I'd like it to do it for each set of initials selected.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    I don't believe this can be done.

  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning zoneblitz61
    Quote Originally Posted by zoneblitz61 View Post
    Is there a way to add comments to the initials so if you mouse over it you can see who the person's name is. I.e. You select the initials JS and when you mouse over it it says "John Smith"
    As Mallycat has stayed there is no native property in Excel to do this, however Jaafar Tribak over at Mr Excel has successfully demonstrated this in this thread (I seem to remember our very own Leith Ross coming up with a routine to do this also, but couldn't find it - I could be wrong). It uses all sorts of messy mousehooks and APIs so don't expect it to be a simple fix - but it does work amazingly well.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Forum Contributor
    Join Date
    08-28-2006
    Posts
    280

    Take a look at the attachment

    zoneblitz61,

    I don't know if this is what you're looking for, but it may give you some ideas. It was posted sometime ago and I used it for a call index on the office computer. Take a look. Hope it helps.

    Dean
    Attached Files Attached Files

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello zoneblitz61,

    This actually involves quite a few techniques to make it work. Fortunately, there are no hooks or API calls needed to make it work. You should refer to Sheet1 of the attached workbook to follow what I am saying.

    The worksheet contains 2 named ranges: Initials and Names, one helper cell in E2 and a validation drop down list in cell G2 that displays Initials.

    The helper cell has the following formula:
    Please Login or Register  to view this content.
    This formula returns the name for the selected initials.

    The next piece of the puzzle is the Worksheet_Change event macro. This will place the contents of the helper cell (name) into the comment text. If the validation doesn't contain a comment, the macro will create one.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-12-2017
    Location
    VietNam
    MS-Off Ver
    2013
    Posts
    1

    Re: comments for drop down list items?

    Thanks so much , this is all what i need as well.

  7. #7
    Registered User
    Join Date
    01-15-2015
    Location
    London
    MS-Off Ver
    7
    Posts
    32

    Re: comments for drop down list items?

    Hi Leith Ross,

    This is very useful, thank you very much. However from the below code it is only for cell G2 (where the drop down is), what if need to drag the drop down comments with validation to the whole column i.e. $G$:$G$ -- as it tried it this way and the range does not work.

    Thanks

  8. #8
    Registered User
    Join Date
    03-25-2020
    Location
    Illinois
    MS-Off Ver
    2016
    Posts
    10

    Re: comments for drop down list items?

    Hey Leith,

    Thanks for this method! Would it be possible to use this for pictures vs text in the comment box? I have a parts spreadsheet that uses dropdowns and I'd like to have the picture show up when the mouse hovers over the drop down selection. Same style as you worked it out but using pictures vs text.

    Thanks,

  9. #9
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,179

    Re: comments for drop down list items?

    Hi Cells4me,

    Two things

    1) It would be in your best interest to post your own thread
    2) It's a Forum rule not to hijack a thread

    Administrative Note:

    Welcome to the forum.

    We are happy to help; however, while you feel your request is similar to this thread, experience has shown things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding items in column which are NOT in a given list
    By schuc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-07-2007, 12:43 PM
  2. Colour of List Items
    By RobynC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2007, 11:44 AM
  3. Sorting Items in a Drop Down List
    By sdrumgo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-29-2007, 03:19 PM
  4. Combining Items in a list
    By Zoomdweebie in forum Excel General
    Replies: 1
    Last Post: 12-13-2006, 11:51 AM
  5. Replies: 6
    Last Post: 12-05-2006, 05:33 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1