Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete enter key rectangles in a cell.
I am using a Textbox on a form to enter data into a cell.
Code: ActiveCell=UserForm1.TextBox1.Text When the user presses ENTER in the TextBox small rectangles appear in the cell. How do I prevent this happening? Thanks for any help! OS is XP and Excel 2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete enter key rectangles in a cell.
It's very hard to suggest anything with so little information, eg what's the
state of MultiLine & WordWrap in the textbox and WordWrap in the cell, what occurs when user presses Enter (normally that will simply exit the text box), or is that control enter, where is the code (in which event), etc, etc here's a long shot guess ActiveCell = Replace(Me.TextBox1.Text, vbCrLf, vbLf) Regards, Peter T "Maths1" wrote in message ... I am using a Textbox on a form to enter data into a cell. Code: ActiveCell=UserForm1.TextBox1.Text When the user presses ENTER in the TextBox small rectangles appear in the cell. How do I prevent this happening? Thanks for any help! OS is XP and Excel 2003 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete enter key rectangles in a cell.
Thank you for the prompt reply.
Your long shot was a direct hit - Fantastic! The textbox EnterKeyBehaviour, MultiLine & WordWrap are set to TRUE and also WordWrap in the cell. The user transfers the text to the Sheet using a CommandButton click event. Many thanks again "Peter T" wrote: It's very hard to suggest anything with so little information, eg what's the state of MultiLine & WordWrap in the textbox and WordWrap in the cell, what occurs when user presses Enter (normally that will simply exit the text box), or is that control enter, where is the code (in which event), etc, etc here's a long shot guess ActiveCell = Replace(Me.TextBox1.Text, vbCrLf, vbLf) Regards, Peter T "Maths1" wrote in message ... I am using a Textbox on a form to enter data into a cell. Code: ActiveCell=UserForm1.TextBox1.Text When the user presses ENTER in the TextBox small rectangles appear in the cell. How do I prevent this happening? Thanks for any help! OS is XP and Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel to enter a cell and delete the last character typed? | Excel Programming | |||
loop through rectangles on worksheet | Excel Programming | |||
How do I enter a formula that will delete a line when a cell = 0? | Excel Worksheet Functions | |||
Clearing rectangles | Excel Programming | |||
Determine if cell was modified by Enter , Paste or Delete | Excel Programming |