Yes you can display a message that pops up upon hovering over a cell and displays a value from another cell.
Here are the steps for doing it:
Creating a dynamic Message that grabs value from a cell
Say I want to create an information message in Cell A12 that grabs the result of a payment function in cell B7. If the Price (in cell B2) or the down payment (in cell B3) change the PMT function updates and my information message in cell A12 updates as well.
Part A: Where to write the code?
Right Click on the Sheet Tab >> Select “View Code’
At the top of the visual Basic Editor there are 2 Drop Lists; From The left one >> Select Worksheet, from the Right one >> select Change.
Remove the Selection Change Sub and keep the Worksheet_Change Sub
Part B: Copy and Paste the code between the 2 lines: Private Sub & End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range(“B2”).Address Or Target.Address = Range(“B3”).Address Then
On Error Resume Next
.InputMessage = Range(“B7”).Value
I explained it in full details in Blog article on "Comments", Here is a link for your reference