LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't see all of the paragraph text in the cell. KW Excel Discussion (Misc queries) 3 October 25th 06 02:16 PM
Starting a new paragraph within a cell Kath firman Excel Discussion (Misc queries) 2 January 5th 06 03:34 PM
how do i make a paragraph appear in one cell area? mmuradian Excel Worksheet Functions 3 April 8th 05 08:46 PM
Can not see all of a pasted paragraph from Word in a cell. Kat Excel Discussion (Misc queries) 2 December 23rd 04 06:37 PM
Enter= New Paragraph in Text cell? DangerMouse114[_9_] Excel Programming 2 June 5th 04 04:52 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"