| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display remaining txt file which overflowed MsgBox display?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file will not open | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Hybrid Mode
