+ Reply to Thread
Results 1 to 3 of 3

Text Box Returning Only 255 Characters to Sheet

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Pleasant Hill, CA
    MS-Off Ver
    Excel 365
    Posts
    27

    Text Box Returning Only 255 Characters to Sheet

    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?

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Text Box Returning Only 255 Characters to Sheet

    Have you inadvertently set the max length property ? - as your profile shows 'Excel 2007' there may be limitations in older 32 bit apps.
    Try the attached form and see if you can overcome the limitation - this does work when used with 2010.
    Another thought is your file saved as an old .xls - try saving as a .xlsm if possible.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  3. #3
    Registered User
    Join Date
    02-06-2013
    Location
    Pleasant Hill, CA
    MS-Off Ver
    Excel 365
    Posts
    27

    Re: Text Box Returning Only 255 Characters to Sheet

    Thanks for the input.

    I finally figured out the problem which was due to incorrectly formatting the return value.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If function formula Returning value from different sheet based on text in Cell
    By kenny scott in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2020, 11:39 AM
  2. Replies: 1
    Last Post: 09-20-2014, 03:49 PM
  3. Returning Special Characters
    By sathishkm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2013, 04:52 PM
  4. Removing characters out of text used for sheet name
    By wrigh333 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-17-2012, 11:25 AM
  5. Returning few characters from a certain position
    By Tabraiz in forum Excel General
    Replies: 2
    Last Post: 11-09-2011, 11:35 AM
  6. Replies: 6
    Last Post: 07-15-2009, 07:44 AM
  7. Returning Characters From A String
    By Solarissf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2006, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1