dynamic hover info

[roscoe]

I was asked if there was a way to tie a lookup feature to a cell such that when hovering over a cell a popup would appear with data relevant to the contents of that cell. Example: He built a calendar with a lookup feature that finds sunrise and sunset for a given day. He'd like to hover over a dater and have the sunrise/sunset data show in a hover "popup".

Any chance that this is doable? I suggested a user defined function that acted on the active cell that presented the results in either a set pair of cells or a keyboard macro that puts the data in a message box.

 

[VBACO]

I would probably use the cell comment box as the popup. You could have a macro just assign each entry based on your formula.

 

[roscoe]

but can that be done with a simple hover?