Best Way to Display a Large Amount of Data in a Single Cell

[daedelous00]

I have a spreadsheet which is auto-generated based on a long VBA script. In Column A I have some instances where there exists a large amount of text inside the cell. I do not want to resize the cell. What is the best way to view this data? (It would need to be automatically done with each iteration)

Here's what I've tried so far:

1) Data Validation Input Message.
Problem: Character limit is far too short

2) Making a Worksheet_SelectionChange code changein the appropriate sheet so that when you click on cells in Column A, a message box appears displaying the content.
Problem: This is perfect except I don't know how to turn this functionality off while I run a macro in a separate module (I know about the Application.EnableEvents = False/True commands, but my macro can't be put in between these commands as it's not located in the sheet code). Because I can't turn it off, the SelectionChange errors out with an Out of Memory error whenever my VBA script is run.

3) Inserting comments that contain the contents of the cell.
I haven't tried this yet, but I'm worried that the tiny comment boxes won't do a good job at displaying lines upon lines of data.

Any suggestions? I would love a way to make #2 work but would gladly accept any alternative that works.

[shg]

... but my macro can't be put in between these commands as it's not located in the sheet code

You can turn events on and off with code in any module.

[daedelous00]

Shg,

Just tried that. Still running out of memory. For reference, here is the command I'm using for the Worksheet_SelectionChange code:

Please Login or Register  to view this content.

[daedelous00]

Nevermind! I moved the Application.EnableEvents = False up a few lines to the very top of the macro and it works. Thanks!