View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default '?' 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