View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kali Kali is offline
external usenet poster
 
Posts: 3
Default Text box in form truncates information. Please help

Hello

I have a problem, hope you can help me.
I have an Excel Form that has several text boxes, user
will enter information and data will be saved in a
spreadsheet.

The problem is: text box truncates text entered.

I am using
ActiveCell.Value = myTextBox.Text
ActiveCell.Value = Replace$(ActiveCell.Text, vbCr, "")

Thanks!
Kali