adam_daunhauer
asked on
Excel Sheet Hover Over Cell To Display Data
Basically this is what I want:
I want to be able to hover my cursor over a cell in an excel sheet that then brings up a box showing data that is entered in another sheet within the workbook.
Example:
In a workbook I have 2 sheets one labeled names and one labeled ages. On the names tab/sheet I want to be able to hover over someones name (let's say that user is in A1 on the names sheet) I want it to display a number that I have already manually entered on the ages sheet in cell B4.
So let's say I have 45 entered in cell B4 on the ages sheet. When I hover over cell A1 on the names sheet a pop up is displayed that says 45
I want to be able to hover my cursor over a cell in an excel sheet that then brings up a box showing data that is entered in another sheet within the workbook.
Example:
In a workbook I have 2 sheets one labeled names and one labeled ages. On the names tab/sheet I want to be able to hover over someones name (let's say that user is in A1 on the names sheet) I want it to display a number that I have already manually entered on the ages sheet in cell B4.
So let's say I have 45 entered in cell B4 on the ages sheet. When I hover over cell A1 on the names sheet a pop up is displayed that says 45
What is the link between A1 and b4?
You could use some code to add the information to the cell as a comment when the mouse is hover the cell and then remove the comment when the mouse exits the cell, something like this:
Range("B2").AddComment
Range("B2").Comment.Text Text:=Cells(myRange.Row, 1)
Hope that you get the general idea...
jppinto
Range("B2").AddComment
Range("B2").Comment.Text Text:=Cells(myRange.Row, 1)
Hope that you get the general idea...
jppinto
ASKER
rorya - I am dumbing it down a little this is actually an access file that has data entered into it and then an excel sheet that was some macros running (rolling months etc) I am looking for a quick fix without having to add another column into the excel sheet.
jppinto - I do not see here where it references the second sheet that it is pulling the data from. I am not a programmer.
Is it something like this for the example I gave?
Range("A1").AddComment
Range("A1").Comment.Text Text:=Cells("ages" "B4")
jppinto - I do not see here where it references the second sheet that it is pulling the data from. I am not a programmer.
Is it something like this for the example I gave?
Range("A1").AddComment
Range("A1").Comment.Text Text:=Cells("ages" "B4")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that is exactly what I am looking for