Pop-up display in excel

[atandon]

Hi All,

I have a column where each cell has very large amount of data. Now I do not want to ruin the symmetry of by excel by increasing the column width and row height.
So is it possible that when I click on that cell, then the contents are displayed in a separate pop-up window?

Otherwise any other pointers on how to display a cell with large contents will be greatly appreciated.

Regards
Anubhav

[humdingaling]

when you click on the cell does it not display the whole cell information in the formula bar?

[atandon]

Yes it does. But I want a separate pop-up.
Reason being that for the formula bar as well, I will have to adjust length of the formula bar. So I do not want to do that. A separate pop-up will look more neat:-)

Cheers

[humdingaling]

i suppose pressing F2 would not suffice either then

only other option i can think of is to create a text box
then insert a selection change code in VBA

something like

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    ActiveSheet.Shapes.Range(Array("TextBox 1")).Select
    Selection.ShapeRange(1).TextFrame2.TextRange.Characters.Text = Target.Value
End Sub

[Andy Pope]

you could store the same information in the cells comment.