How to view content of a cell containing a very long string?

Posted by Joel Horowitz on December 16, 2001 2:38 AM

Hye,

I am a little annoyed by this problem: I have a column that contains a formula (a vlookup in an external file) that returns a very long string (500+ characters). I can't redimension the rows/columns to view the whole content because it would make my database hard to read. So what I would like is to see the whole content of the cell in the formula bar for instance. Is there a setting that allows that?
I know one option is to copy/paste values in another column, but then I would have to do that everytime I add record to my database.

Thanks,

Joel

Posted by Bruno on December 17, 2001 1:43 AM

Joel, try this,

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.StatusBar = ActiveCell.Value
End Sub

Bruno

Posted by Joel Horowitz on December 20, 2001 3:07 PM

Thanks Bruno,

that's very cool, but unfortunately, it doesn't work once the string really become long. But at least it taught me how to use the status bar to display some information...