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

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

Dermot

New Member
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
 

Attachments

Chihiro

Excel Ninja
Assuming Column A holds unique value. Something like...
Code:
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.
 

Dermot

New Member
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:

Chihiro

Excel Ninja
? 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.
 

Dermot

New Member
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)
 

vletm

Excel Ninja
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?
 

Attachments

Dermot

New Member
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!
 

vletm

Excel Ninja
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'!
 

Dermot

New Member
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!
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'!
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
 

vletm

Excel Ninja
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?
 

Dermot

New Member
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?
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.
 

Dermot

New Member
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'!
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.
 

vletm

Excel Ninja
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!
 

Dermot

New Member
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!
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.
 

vletm

Excel Ninja
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?
 

Dermot

New Member
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?
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.
 
Top