Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'?' displayed in excel: when I hit enter for a new line in textbox
I have a textbox which accepts large amout of text. So I set the
'EnterKeyBehaviour' property to True, as users can hit enter for a new line. Once I Set EnterKeyBehaviour property to True, The cell in excel where this textbox value is stored displays a '?' where ever I hit enter. For eg: If in userform text box I entered: one two three four five six seven the excel output displays: one two three four? five six seven? These question marks are displayed where ever I hit enter for a new line in the textbox. I hope I made it clear Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
'?' displayed in excel: when I hit enter for a new line in textbox
sounds like you are showing the carriage return.
Try this approach and see if solves problem: Range("A1").Value = Application.Substitute(TextBox1, Chr(13), "") -- jb "sam" wrote: I have a textbox which accepts large amout of text. So I set the 'EnterKeyBehaviour' property to True, as users can hit enter for a new line. Once I Set EnterKeyBehaviour property to True, The cell in excel where this textbox value is stored displays a '?' where ever I hit enter. For eg: If in userform text box I entered: one two three four five six seven the excel output displays: one two three four? five six seven? These question marks are displayed where ever I hit enter for a new line in the textbox. I hope I made it clear Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
'?' displayed in excel: when I hit enter for a new line in textbox
That enter key is two characters line feed and carriage control.
So fix the string before you plop the value into the cell. Worksheets("sheet9999").range("A1").value _ application.replace(me.textbox, vbcr, "") The linefeeds are the alt-0101 (char(10)'s) and you'll want to keep them. sam wrote: I have a textbox which accepts large amout of text. So I set the 'EnterKeyBehaviour' property to True, as users can hit enter for a new line. Once I Set EnterKeyBehaviour property to True, The cell in excel where this textbox value is stored displays a '?' where ever I hit enter. For eg: If in userform text box I entered: one two three four five six seven the excel output displays: one two three four? five six seven? These question marks are displayed where ever I hit enter for a new line in the textbox. I hope I made it clear Thanks in advance -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
'?' displayed in excel: when I hit enter for a new line in tex
Thans a lot john, This worked out great
"john" wrote: sounds like you are showing the carriage return. Try this approach and see if solves problem: Range("A1").Value = Application.Substitute(TextBox1, Chr(13), "") -- jb "sam" wrote: I have a textbox which accepts large amout of text. So I set the 'EnterKeyBehaviour' property to True, as users can hit enter for a new line. Once I Set EnterKeyBehaviour property to True, The cell in excel where this textbox value is stored displays a '?' where ever I hit enter. For eg: If in userform text box I entered: one two three four five six seven the excel output displays: one two three four? five six seven? These question marks are displayed where ever I hit enter for a new line in the textbox. I hope I made it clear Thanks in advance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
'?' displayed in excel: when I hit enter for a new line in textbox
There are a bunch of typos in this message:
Worksheets("sheet9999").range("A1").value _ = replace(me.textbox1.value, vbcr, "") The linefeeds are the alt-0010 (char(10)'s) and you'll want to keep them. If you're using or supporting xl97, you can use: Worksheets("sheet9999").range("A1").value _ = application.substitute(me.textbox1.value, vbcr, "") Dave Peterson wrote: That enter key is two characters line feed and carriage control. So fix the string before you plop the value into the cell. Worksheets("sheet9999").range("A1").value _ application.replace(me.textbox, vbcr, "") The linefeeds are the alt-0101 (char(10)'s) and you'll want to keep them. sam wrote: I have a textbox which accepts large amout of text. So I set the 'EnterKeyBehaviour' property to True, as users can hit enter for a new line. Once I Set EnterKeyBehaviour property to True, The cell in excel where this textbox value is stored displays a '?' where ever I hit enter. For eg: If in userform text box I entered: one two three four five six seven the excel output displays: one two three four? five six seven? These question marks are displayed where ever I hit enter for a new line in the textbox. I hope I made it clear Thanks in advance -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform textbox: hit enter to start writing in a new line | Excel Programming | |||
Line-by-line formatting in Excel 2007 Textbox | Excel Programming | |||
How to use ENTER in a TextBox in Excel 2007 | Excel Programming | |||
Can you Click the "Enter" key to go to the next line in a Textbox without Exiting the Textbox ? | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming |