I have a simple form utilizing VBA that is used for data entry. The user calls the form, enters data and upon saving the data is written to specific cells in the workbook sheet. The problem I am having is that one of the data points is a comment field text box that upon saving only writes the first 255 characters to the sheet. I have set MultiLine and WordWrap to TRUE. I cannot think of any other properties for the TextBox that might help.
Any ideas how I can get the TextBox to return more that 255 characters to the sheet?
Bookmarks