ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text boxes in forms (https://www.excelbanter.com/excel-programming/421144-text-boxes-forms.html)

Risky Dave

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



atpgroups

Text boxes in forms
 
On Dec 11, 10:40*am, Risky Dave
wrote:

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?


Either set the TextBox EnterKeyBehaviour to FALSE in the properties
pane when designing the form, or set the same property programatically


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com