Displaying Results . . .

[Fable]

Greetings,

I got a Date value in cell A1, and I would like too mouse over it
click on it, have it displace data from a vlookup in another sheet
Just like a chart when you mouse over a bar and it tells the data it
using.

Is it possible to emulate that through a comment or msgbox?

Thanking you in advance

 

[Frank Kabel]

Hi
1. Mouseover won't work as the worksheet cells do not have a mouseover
event (and I doubt you want to use Windows API calls)
2. You culd use a comment and change it with a worksheet_change event
if the other cell changes.

you may provide some more details what kind of data you want to display
and how this data is 'calculated'