Hover Text in excel

You could perhaps use Cell Comments ?

You could in turn use a Worksheet_Change event to populate the cell comment as and when the cell value is altered, setting the comment according to the entered value... to provide an example we would need a little more info, ie is this to be applied to a specific sheet / range etc...

You could do this with a UDF.

Put this is a code module:

Please Login or Register  to view this content.

In some cell (any cell), put this formula:

=ChangeComment(A1)

Then put Bob, Joe, or anything else in A1.

shg will probably have a more elegant method up his sleeve but one approach might be something along the lines of:

Please Login or Register  to view this content.

To insert the above, right click on the tab containing the PT - select View Code and paste above into resulting window... whenever the PT is refreshed the comments should update accordingly.

Above code assumes there are no other comments on the sheet other than those to reside in the Code PT Items.

EDIT: although the above adds the comments I'm not sure this will work here... you will need to disable the Contextual ToolTips option for the Comments to display (as cell is hovered etc...)

You might like to have a look at Jason Goldmeier's rollover technique:
http://optionexplicitvba.com/2012/09...over-mini-faq/