Easy reading of large text cells

A simple way I could think of(without creating a user form) is:

1. Assign an empty cell in your worksheet and format it with a large font.
2. Switch to visual basic editor.
3. Click on the name of your sheet in project explorer at your left.
4. On the right pane select "Worksheet" from the left drop down and select "SelectionChange" from the right drop down.
5. Now you are in the Worksheet_SelectionChange event.
6. Copy this code between "Private Sub Worksheet_SelectionChange" and "End Sub".

Please Login or Register  to view this content.

Change the "A1" with the address of the cell where you want to see large text.

Now whenever you click on a cell its value will appear on "A1", or whatever address you have chosen, with a large font.

I hope this will satisfy your need.