Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Show Text On Mouse Hover

  1. #1
    Join Date
    14th December 2006
    Posts
    16

    Show Text On Mouse Hover

    hi guys
    how to get cell data / highlight the cell on which mouse hover ?
    is there any way to resolve this problem.
    please reply

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Mouse Hovering On Cell

    I don't think you can do this. No event has been triggered until you click, right-click or double-click.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,042

    Re: Mouse Hovering On Cell

    Use a comment that you insert. A triangle appears in the upper right corner of the cell.
    Regards,

    Wigi

    Excel MVP 2011, 2012, 2013



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  4. #4
    Join Date
    14th December 2006
    Posts
    16

    Re: Mouse Hovering On Cell

    hi
    good to get ideas.
    i have some text/number in the cell.
    on mouse hovering on that cell i want to underline the cell text and highlight it in differnt colour or bold.
    and on click to that cell i want to perform operation using that text.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,042

    Re: Mouse Hovering On Cell

    Parm

    I don't think that will be possible. You can show a comment with text in it, but I wouldn't know how to change that text once you show the comment. The same holds for how to underline text when the comment is shown.

    Wigi
    Regards,

    Wigi

    Excel MVP 2011, 2012, 2013



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  6. #6
    Join Date
    14th December 2006
    Posts
    16

    Re: Mouse Hovering On Cell

    ok wigi
    thanks to be with me ..
    i will explore ur idea and come back to u ASAP.

    regards
    parm

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Mouse Hovering On Cell

    According to my book, you can change comments by using ClearComment and AddComment - would they be usable once the comment is showing? Don't see why not. But nothing happens without a click, I don't think.
    Last edited by ByTheCringe2; December 15th, 2006 at 01:01.

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    9th January 2012
    Posts
    1

    Re: Mouse Hovering On Cell

    Quote Originally Posted by ByTheCringe2 View Post
    According to my book, you can change comments by using ClearComment and AddComment - would they be usable once the comment is showing? Don't see why not. But nothing happens without a click, I don't think.
    Using the above: (ClearComment and AddComment).
    Bear in mind that you place the comments NOT some dynamic text!!
    If you had for example NAMES on the A column and Tom was A3. You place the comments and hovering shows Tom.
    If you change A3 from Tom to John the comment STILL shows Tom!! You have to remove/add comments to "refresh".

    Here is my code if it helps:

    FOR ADDING:
    VB:
    Sub add_comments() 
        Dim rcell As Range 
        For Each rcell In Range("B3:P25") 
            If rcell.Value <> "@" Then 
                rcell.AddComment 
                rcell.Comment.Text Text:=Cells(rcell.Row, 1) & Chr(10) & Cells(2, rcell.Column).Value & Chr(10) & Cells(rcell.Row, rcell.Column).Value 
            End If 
        Next 
    End Sub 
    
    
    FOR REMOVING:
    VB:
    Sub remove_comments() 
        ActiveWorkbook.RemoveDocumentInformation (xlRDIComments) 
    End Sub 
    
    
    ADDITIONALLY FOR FORMATING MY HOVERING TO A LONG BLUE COMMENT BOX:
    VB:
    Sub Format_all_comments_together() 
        Dim MyComments As Comment 
        Dim LArea As Long 
        For Each MyComments In ActiveSheet.Comments 
            With MyComments 
                .Shape.AutoShapeType = msoShapeRoundedRectangle 
                .Shape.TextFrame.Characters.Font.Name = "Tahoma" 
                .Shape.TextFrame.Characters.Font.Size = 12 
                .Shape.TextFrame.Characters.Font.ColorIndex = 2 
                .Shape.Line.ForeColor.RGB = RGB(0, 0, 0) 
                .Shape.Line.BackColor.RGB = RGB(255, 255, 255) 
                .Shape.Fill.Visible = msoTrue 
                .Shape.Fill.ForeColor.RGB = RGB(58, 82, 184) 
                .Shape.Fill.OneColorGradient msoGradientDiagonalUp, 1, 0.23 
                .Shape.ScaleWidth 3.1, msoFalse, msoScaleFromTopLeft 
            End With 
        Next 
    End Sub 
    
    
    Note that for some reason that I'm not going to explore, every time I run the last function the box gets longer!! It helps with long names too. All I did was remove and run the last Sub a few times.

    I hope it helps
    Last edited by fytos; January 10th, 2012 at 00:15. Reason: Correction/addition

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Show Chart On Mouse Hover Over Cell
    By bonnet in forum EXCEL HELP
    Replies: 4
    Last Post: November 24th, 2006, 09:29
  2. Show User Form Value with Mouse Over event
    By mtyrrell13 in forum EXCEL HELP
    Replies: 45
    Last Post: July 22nd, 2006, 00:58
  3. Mouse hover causes cell to display as comment
    By markc in forum EXCEL HELP
    Replies: 5
    Last Post: April 5th, 2006, 07:58
  4. Object visible on mouse hover (click)
    By markc in forum EXCEL HELP
    Replies: 4
    Last Post: March 12th, 2005, 02:21

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
  •  
porno