About Us

Ren

Thanks again Tom youre the MAN!!

Cheers

Ren

"Tom Ogilvy" wrote:

Excel will only display approximately 1024 characters in a cell (even merged
cells). It may vary from this total because the characters will display
until they reach the right edge of the cell (or merged cells)

You can overcome this by putting forced returns in your text. So go near
the last part of your text that is displayed and manually do alt+enter.

This should then cause more text to be displayed.

To do this in code, you have to use Chr(10)

So in the VBE if you had

sStr = "abcd" & _
"efgh" & _
"ijkl" & _
"mnop" & _
"qrstuvwxyz"

you would need to do

sStr = "abcd" & _
"efgh" & _
"ijkl" & chr(10) & _
"mnop" & _
"qrstuv" & chr(10) & _
"wxyz"

Also, you would need to format your box for word wrap.

--
Regards,
Tom Ogilvy

"Ren" wrote in message
...
Greetings to all

I have a form that I created, in that form I also have a box that consist
of
a few cells that I merged together and also given a certain height and
with
the help of Tom and Sharad was able to fit my biggest text.

I was able to fit the entire paragraph in all the boxes. That was with
the
English text, now I have to do the same with the French text and I'm
having a
problem. The French version is always longer then the English.

So I broke the paragraph into section like Tom and Sharad suggested and
for
some unknown reason the last part of the text those not want to wrap to
the
next line, it continues to the edge of the box then disappears.

What am I doing wrong? Even if I reduce the font I get the same problem
the
last part of the paragraph will not wrap to the next line.

Thanks for your HELP!!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation boxes, outputting a final number from the boxes	MDH	Excel Discussion (Misc queries)	1	November 16th 06 12:41 AM
Moving. Want to number boxes and inventory contents of boxes	[email protected]	Charts and Charting in Excel	1	August 29th 06 09:48 AM
Selecting subsets using combo boxes or list boxes	CLamar	Excel Discussion (Misc queries)	0	June 1st 06 07:43 PM
Questions on combo boxes and list boxes.	Marc	New Users to Excel	1	March 14th 06 09:40 AM
How do i create a value for check boxes or option boxes	Tim wr	Excel Discussion (Misc queries)	1	February 9th 06 10:29 PM

Menu

About Us