Mouse Over PopUp display Lookup Result

[Jen B.]

Hi, I have a worksheet where I need to lookup part of the number i.e.,
CGIF00000016-100 and have the function
=VLOOKUP(VALUE(RIGHT(Projects'!A6,3)),Tasks!A1:B28,2, FALSE) to lookup only
the last 3 numbers (Task).
How can I display the result (Description) in a popup when a cell mouseover
occurs on the active cell? Many thanks Jen

 

[Gary''s Student]

Insert a comment and place the result in it.

 

[Jen B.]

Cute. Duh, after reviewing the group like uh I never thought to try that
before posting...Dude, comments don't allow direct formula entry and I'm
talking about thousands of records. I've also tried modifying some some code
that's been offered in similar requests but was unable to get it to work.
Because comments don't allow formulas I moved towards popups as the next
alternative.

 

[Tim Williams]

What's a "popup" if it's not a comment ? Adding and populating comments for
thousands of cells isn't a big deal, assuming you mean to use VBA.

Tim