Displaying Results . . .

F

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
 
F

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'
 
Top