View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How to display remaining txt file which overflowed MsgBox display?

Hi,

The message box will display 1023 characters.

If you can not reduce the quantity of text create your own message box
using a user form.

Cheers
Andy

EagleOne wrote:
2003

My concatenated text string is too large for the MsgBox display. It
displays the first 30 lines and not the remaining four. I could not
enlarge the window nor "slide" the data.

I know that there are four undisplayed because if I "? txt" in the
Immediate window, I see all 34 lines of data.

Any config issues or workarounds?

TIA EagleOne


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info