Qn: Paragraph or LF in ONE Cell??
 

Hello Everyone,

I saw a post on this earlier from another person in dire need, but the
person giving help I don't think explained it very well or solved the
problem. So, I will input my question here. I know this can be done,
because John Walkenbach did it in one of his examples on the CD of his book:
Excel 2002 Power Programming with VBA. I was using one of his samples of
displaying HELP files in your program. Now, to use the program correctly,
the information for the HELP file is stored in ONE cell for each Help item.
Example:

A1: Title of Help (Temperature) A2: Long line of text explaining the
temperature to INCLUDE a LineFeed (paragraph) and more text. How do I input
the Linefeed into one cell to use it as a paragraph and add more text????
Everytime I hit Carriage Return, it exits the cell. In John's sample
program from the CD, he had a blank line (paragraph) in the same cell, how
did he input that?? His program will not recognize any other data except
only what is in Cell A2. Everytime I input data, it will not take a LF or
spills the data over into other cells.
Thanks in Advance.. mv

Paragraph or LF in ONE Cell??
 

When editing the cell, whereever you want a line feed, to ALT+RETURN (or
ALT+ENTER)

This will move to the next line within the text you are Editing.

--
Regards,
Tom Ogilvy

"Michael Vaughan" wrote in message
...
Hello Everyone,

I saw a post on this earlier from another person in dire need, but the
person giving help I don't think explained it very well or solved the
problem. So, I will input my question here. I know this can be done,
because John Walkenbach did it in one of his examples on the CD of his
book:
Excel 2002 Power Programming with VBA. I was using one of his samples of
displaying HELP files in your program. Now, to use the program correctly,
the information for the HELP file is stored in ONE cell for each Help
item.
Example:

A1: Title of Help (Temperature) A2: Long line of text explaining the
temperature to INCLUDE a LineFeed (paragraph) and more text. How do I
input
the Linefeed into one cell to use it as a paragraph and add more text????
Everytime I hit Carriage Return, it exits the cell. In John's sample
program from the CD, he had a blank line (paragraph) in the same cell, how
did he input that?? His program will not recognize any other data except
only what is in Cell A2. Everytime I input data, it will not take a LF or
spills the data over into other cells.
Thanks in Advance.. mv