You could design your own userform using labels or multipage and have almost
limitless space for text.
"John Svendsen" wrote:
Hi All:
I'd sure appreciate some help in finding a way to replace VBA's Inputbox
because of its 255-char limit
While running existing VBA code in Excel 2003, I display text on the screen
using Inputbox, I need to do some small edits to the text and then press
OKm then the VBA code takes this corrected text and goes on.
The Problem is that Inputbox does not deal with long text, I sometimes need
to display and edit 1000-char text.
I have tried, unsuccessfully, to use a VBA textform (over my head I guess).
Can some one please be so kind as to give me a clue as to how to solve my
problem?
Thanks so much,
JS