+ Reply to Thread
Results 1 to 11 of 11

expand textbox character limit in userform

  1. #1
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    expand textbox character limit in userform

    hello,

    i was unsuccessfully trying to find a way to increase character limit in user input form (txtbox). does anyone know how?
    Thank you in advance
    Rome wasn't built in a day

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: expand textbox character limit in userform

    The limit for a textbox is 32k (if not 64k) characters... Why would you want to increase that??

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: expand textbox character limit in userform

    It is possible to put over 10m characters into a textbox on a userform.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  4. #4
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    Re: expand textbox character limit in userform

    well inputing seems to be ok with that, however i set a textbox to retrieve some info from a workbook and it only limits to 255 characters and therefore misses some information

  5. #5
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: expand textbox character limit in userform

    How do you retrieve it?

  6. #6
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    Re: expand textbox character limit in userform

    I use a textbox to display a text depending on what's chosen in a combobx
    HTML Code: 

  7. #7
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: expand textbox character limit in userform

    I do not understand how you will apply percentage format to text?

  8. #8
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    Re: expand textbox character limit in userform

    its not about that is it? its percentge made of 255 < characters :D

  9. #9
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: expand textbox character limit in userform

    I think it is about that - I think Format function is truncating your text. I do not see why you are using it.

  10. #10
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    Re: expand textbox character limit in userform

    sorry I thought you were joking, but i removed formating and it worked! Thanks a lot!

  11. #11
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: expand textbox character limit in userform

    You are welcome.

+ 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. Limit Userform TextBox Characters
    By jennie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2011, 02:17 PM
  2. Userform textbox vertical scrollbars not at bottom limit - show more...
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2009, 08:59 PM
  3. 6 Character limit on userform combo box source?
    By kanuvas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2008, 06:59 AM
  4. Counting character in textbox in userform
    By Gert-Jan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2006, 07:50 AM
  5. [SOLVED] limit character in textbox
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2005, 05:05 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