Is there a way that the contents of a cell can be displayed in a pop-up
window when you hover the mouse pointer over it, ie. the same way that
comments are displayed.

The pop-up required for my purposes will include text only and will not
require any formatting to be displayed

Think you could play with the sub below to write the cell's contents into its
comment. Install* the sub, then just select the range on the sheet, & run the
sub.

*To install: Press Alt+F11 to go to VBE, click InsertModule, then copy n
paste the sub into the code window (the empty white space on the right).
Press Alt+Q to get back to Excel.

Sub CellToComment()
For Each cell In Selection
If Len(cell) 0 Then
If cell.Comment Is Nothing Then
cell.AddComment
End If
cell.Comment.Text Text:=cell.Value
End If
Next cell
End Sub

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Oldersox" wrote:
Is there a way that the contents of a cell can be displayed in a pop-up
window when you hover the mouse pointer over it, ie. the same way that
comments are displayed.

The pop-up required for my purposes will include text only and will not
require any formatting to be displayed