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: 161
Default Text boxes in forms

Hi,

I'm sure this is a really easy one, but...

I have a set of forms that capture user-inputed data. Each form uses text
boxes to record the input and copy it to specific cells on a spreadsheet.

When users need to input several different items into the same text box, how
do I capture the carriage return to put these on different lines within the
same box? At the moment, the carriage return forces the cursor to move to the
next text box on the form (in the same way that the Tab key moves about).

What I want is the text from each box on the form copied to specific cells
(I can do this ok) and formatted so that it looks as if each cell line has
had ALT-ENTER used

Hope this makes sense!

TIA

Dave


 
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
Updating text boxes on forms Matt McQueen Excel Programming 7 January 14th 08 07:57 AM
text boxes on forms steve Excel Programming 1 September 12th 06 02:55 PM
Forms - Loop thru text boxes Michael Beckinsale Excel Programming 9 April 10th 06 06:54 PM
forms / text boxes JT Excel Programming 1 January 23rd 06 08:07 PM
Setting Property Values of Text Boxes within Forms SkyEyes Excel Programming 1 July 1st 05 07:06 PM


All times are GMT +1. The time now is 08:52 AM.

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"