1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Sheet Hover Over Cell To Display Data (without using VBA)

Discussion in 'Ask an Excel Question' started by Dermot, Feb 26, 2019.

  1. Dermot

    Dermot New Member

    Messages:
    13
    Hello all,

    I have scoured the the net to find a none VBA method of displaying a cell value from another cell by hovering over the active cell.

    just as how "Khalid NGO Excel Ninja" gave an example using a hyperlink (Right Click > Insert > Hyperlink > Place in This doc > ScreenTip), my result should end up looking something like this, only that it should display a value that it is making reference to.

    so if I have a column A for example having the values shown below, I would want see the name values of column C displayed when I hover/select the cells in column A

    Column A column B
    141 $ 600.00
    30 $ 300.00
    94 $ 3,000.00
    67 $ 3,000.00
    329 $ 300.00


    Column C Name
    141 Dermot
    30 Johnson
    94 Lesa
    67 Meliesa
    329 John

    Attached Files:

  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,299
    Assuming Column A holds unique value. Something like...
    Code (vb):
    Sub HyperlinkTip()
    Dim dic As Object
    Dim cel As Range
    Dim x
    Set dic = CreateObject("Scripting.Dictionary")
    With Sheets("Sheet1")
        For Each cel In .Range("A3:A" & .Cells(Rows.Count, 1).End(xlUp).Row).Cells
          dic(cel.Value) = "'" & cel.Parent.Name & "'!" & cel.Offset(, 1).Address & "~" & cel.Offset(, 1).Value
        Next
    End With
    With Sheets("Sheet2")
        For Each cel In .Range("C2:C" & .Cells(Rows.Count, 3).End(xlUp).Row).Cells
            x = Split(dic(cel.Value), "~")
            cel.Offset(, 1).Hyperlinks.Add Anchor:=cel.Offset(, 1), Address:="", SubAddress:=x(0), ScreenTip:=x(1)
        Next
    End With
    End Sub
    Then you could link the sub to button, or use Workbook_Open event as trigger to update link and screentip.
  3. vletm

    vletm Excel Ninja

    Messages:
    4,918

    Attached Files:

  4. Dermot

    Dermot New Member

    Messages:
    13
    I Am not seeing the cell values (names) displayed. however is seems like it is a workable solution, only that I really don't understand it. can you give me more details on the excel file you posted vletm? it is giving me a "cannot open specified file" error
    vletm
    vletm
    Last edited: Feb 26, 2019
  5. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,299
    OH, for my code. I had it reversed. Just reverse sheet and range reference in code.
  6. Dermot

    Dermot New Member

    Messages:
    13
    I Dont want to use code in this spreadsheet because I want it to phone usable
  7. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,299
    ? Code is only needed for initial generation. Nothing else. Once hyperlink is created you don't need code.

    Without code, you just need to manually create hyperlink to cell in the same document. And fill in "ScreenTip" with value (string) that you want.
  8. Dermot

    Dermot New Member

    Messages:
    13
    Het guys I am so sorry I have to revamp this question. I sent an .xlm that had vba code. I had no idea I did, so the sheet cannot be functional on a phone using the excel app. and I want it solely for this purpose. And used my phone and tried the sample code and it did not work.


    So its is what my new question will be: How to see a cell's reference value displayed when a cell is selected. (Must be applicable to smartphones)
  9. vletm

    vletm Excel Ninja

    Messages:
    4,918
    Dermot
    So far 'smartphones' would have challenges with macros.
    You've asked 'Excel Sheet Hover Over Cell To Display Data'.
    Should You 'upload' You smartphone here ... hmm?... then it could test or how?

    Attached Files:

  10. Dermot

    Dermot New Member

    Messages:
    13
    I just tried the file on my smartphone (android) and when I selected a link (in col A) there was a pop up saying "open link" which had further options when selected.

    It wud be nice to see the reference value "Dermot" (on sheet 2) instead of "open link". This wud be perfect!
  11. vletm

    vletm Excel Ninja

    Messages:
    4,918
    Dermot
    You asked 'Hover Over Cell To Display Data' ... NOT select.
    For me those are like eating and breathing
    ... and not good to do same time!
    Slide You finger over col A cells ... not activate 'link'!
  12. Dermot

    Dermot New Member

    Messages:
    13
    Okay. Well, any of these options (hover/select) would be fine for me I just need a workable one, that displays the name values whenever I enter its respective number
  13. vletm

    vletm Excel Ninja

    Messages:
    4,918
    Dermot
    ... well ...
    As long time as You ask something free
    then You should think first what do You need!

    As I wrote in Your almost double case,
    You way,
    means double or more work for those
    who try to help You!
    ... in everyday life ... this should mean double bill!

    If You would like to get to the moon,
    then ask
    how to get to the moon?
    not
    how to get to Port Antonio?
  14. Dermot

    Dermot New Member

    Messages:
    13
    Okay Thanks for that comment. I Usually don't Make post like those. I am kinda unfamiliar with this forum and also with how excel works to some extent. Hence, my upload of a macro enabled sheet, and also taking for granted that it would work on my smart phone with out testing.

    Please forgive me. vletm, I really want this to work, I am willing to go to great extent. Please assist if you can. Thank you.
  15. Dermot

    Dermot New Member

    Messages:
    13
    Plus I'm still learning to be more specific..... should have really said hover/select.... which would not mislead other web users... work in progress.
  16. vletm

    vletm Excel Ninja

    Messages:
    4,918
    Dermot
    Fileformat (.xlsm, .xlsb, .xlsx ...) 'challenge' ...
    So far, if use with 'normal platform' then 'normally' no matter,
    but if ... not ... then there could be challenges.

    You asked 'Hover Over Cell To Display Data' ... NOT select.
    Can You use that like 'Hover'? Yes/No?
    or
    Should You always 'Select'? Yes/No?
    I do not have Your smartphone, I cannot test that!
  17. Dermot

    Dermot New Member

    Messages:
    13
    Ok well the I should be using a galaxy s6 or a nokia plus which are both android phones (so basically android platform). So as I said I am not necessarily looking for both features to work at the same time (Ie hover & select). If I can get both no problem but I am strickly looking for a feature (selection preferably) that when selected will display its reference value.
  18. vletm

    vletm Excel Ninja

    Messages:
    4,918
    Dermot
    Did You noticed that I tried to ask two Yes/No -questions?
    I noticed that I didn't get any answers!
    If I cannot get answers,
    then how could I or someone else try to help You?
  19. Dermot

    Dermot New Member

    Messages:
    13
    I am sorry man, it is just a communication issue. I thought you were asking if I need to switch between hover/select using Yes/No.

    Ok so to answer your question: you could probably try hover yes/now....
    Let me see what you are thinking.

Share This Page