View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Svendsen John Svendsen is offline
external usenet poster
 
Posts: 11
Default How to overcome Inputbox 255-char limit?

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