How to have text hovering over a cell

Hi there,
I am looking for a way to have text hover over a cell when the mouse is moved on top of it.

For example

cell 1 - 5 hours
cell 2 - $10,000

I would like to be able to hover over either cell and text appear saying (using formula)

"Cost Per Hour $2,000"

Is this something people have had been able to achieve successfully?

I have seen some VB script for doing this on charts - but not on cells.

There will be thousand of entries which is why I am not looking to use a cell comments box

Thanks

Rupert

If this seems impossible I could live with clicking into the cell to have the information appear?

Let me know what you think

RJ

You can use this in worksheet_change event to display text, but only when you select the cell not
when the mouse is moved on top of it.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Selection.Validation
.Delete
.Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator _
:=xlBetween
.InputMessage = Target.Value
.IgnoreBlank = True
.InCellDropdown = True
.ShowInput = True
.ShowError = True
End With
End Sub

Originally Posted by kvsrinivasamurthy

You can use this in worksheet_change event to display text, but only when you select the cell not
when the mouse is moved on top of it.

This is great, although I am having trouble working out where to put in the formula - i.e A1/B1 so I get the cost per hour in the hover box? I have the hover box working great, but it just shows the value of the cell I am in

Thanks

Originally Posted by kvsrinivasamurthy

You can use this in worksheet_change event to display text, but only when you select the cell not
when the mouse is moved on top of it.

I am getting a run-time error 1004: application-defined or object-defined error. Can you please help me? When I debug, it is highlighting the following:

.InputMessage = Target.Value

Hi,

Can you explain it elaborately?

Thanks in advance!