Display text in cell in large format

Hi all, What VBA would I have to use to make any cell I select by double clicking it make a pop-up window appear and show what was in that cell.
I have a worksheet with very small text ( shrink to fit ) and some cells are very hard to read, this option would enable you to click any cell to view its contents.
Or - can vba make a sort of magnifying glass appear by floating the cursor over cells within a certain page appear larger than whats on screen normally?

Any help would be appreciated.