View cell contents as a pop-up window (similar to comments window)

  • Thread starter Thread starter Oldersox
  • Start date Start date
O

Oldersox

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 Insert>Module, 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
 
Back
Top