View cell contents as a pop-up window (similar to comments window)
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 |
View cell contents as a pop-up window (similar to comments window)
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 |
All times are GMT +1. The time now is 08:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com