| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with long text
Thanks for the info.
-- Gary''s Student - gsnu2007a "djExcel" wrote: I found a solution. I just had to divide the whole text into e.g. 100 character long pieces and then add those pieces to a text box one by one. I'm answering to my own question just in case someone else is having same kind of problems. Here is an example. I have already divided the whole text into pieces and placed them into an array Arr_text() and the number of pieces is in the variable ArrCnt. ActiveSheet.Shapes("Text Box 1").Select With Selection .Characters.Text = Arr_text(1) If ArrCnt 1 Then 'check if there are more than one piece For X = 2 To ArrCnt .Characters(Start:=X * 100).Text = Arr_text(X) Next X End If End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
| How do I prevent a long string of text from wrapping in a text fil | Excel Discussion (Misc queries) | |||
| Long Date - Long Date = text is days | Excel Discussion (Misc queries) | |||
| Problems with long columns. | Excel Discussion (Misc queries) | |||
| Text too long | Excel Programming | |||
Hybrid Mode
