+ Reply to Thread
Results 1 to 7 of 7

Hover Text in excel

  1. #1
    Registered User
    Join Date
    06-19-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    23

    Hover Text in excel

    Hi there,

    I need to have hover text in my spreadsheet as the whole spreadsheet is very huge.

    For example, If the user moves the mouse to a range of cells for example, cell A2 which contains a code (NOVO1), a hover text will appear with the description (apple), if code (NOVO2), the hover text is (Orange).

    Any one can help me on this?
    Thanks!

  2. #2
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: Hover Text in excel

    You could perhaps use Cell Comments ?

    You could in turn use a Worksheet_Change event to populate the cell comment as and when the cell value is altered, setting the comment according to the entered value... to provide an example we would need a little more info, ie is this to be applied to a specific sheet / range etc...

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,419

    Re: Hover Text in excel

    You could do this with a UDF.

    Put this is a code module:

    Please Login or Register  to view this content.
    In some cell (any cell), put this formula:

    =ChangeComment(A1)

    Then put Bob, Joe, or anything else in A1.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    06-19-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Hover Text in excel

    Thanks Guys for replying...

    I have attached a very simple spreadsheet to give an example of what I am looking for. Pardon me as I was not clear in my initial post.

    In my spreadsheet, i have a pivot table. What i am hoping to be achieved here is when the mouse over to the cells that contains the different code, the corresponding description (from lookup sheet) will appear as a hover text.

    Is that possible?
    Attached Files Attached Files

  5. #5
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: Hover Text in excel

    shg will probably have a more elegant method up his sleeve but one approach might be something along the lines of:

    Please Login or Register  to view this content.
    To insert the above, right click on the tab containing the PT - select View Code and paste above into resulting window... whenever the PT is refreshed the comments should update accordingly.

    Above code assumes there are no other comments on the sheet other than those to reside in the Code PT Items.

    EDIT: although the above adds the comments I'm not sure this will work here... you will need to disable the Contextual ToolTips option for the Comments to display (as cell is hovered etc...)
    Last edited by DonkeyOte; 07-28-2009 at 05:51 AM.

  6. #6
    Registered User
    Join Date
    06-19-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Hover Text in excel

    Thanks for the script...
    i will give it a try later... thanks agaiin dude!

  7. #7
    Registered User
    Join Date
    09-24-2010
    Location
    Lake Garda, Italy
    MS-Off Ver
    2010 Professional Plus (Italian/English/German)
    Posts
    7

    Re: Hover Text in excel

    You might like to have a look at Jason Goldmeier's rollover technique:
    http://optionexplicitvba.com/2012/09...over-mini-faq/
    David Macdonald
    Win7 Enterprise - Excel 2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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