none
Discussion on textbox in userform. RRS feed

  • Question

  • Which property of textbox cannot be changed at
    runtime and what?s the maximum size of a textbox?
    Tuesday, September 29, 2015 3:57 PM

All replies

  • About the Maximum Size:

    WinNt4FamilyWin2kFamilyWin2kProfessionalWin2kServerWin2kDatacenterWinXpFamily:

    If the MaxLength property is set to 0, the maximum number of characters the user can enter is 2147483646 or an amount based on available memory, whichever is smaller.

    WinMe:

    If the MaxLength property is set to 0, the maximum number of characters the user can enter is 32,766 or an amount based on available memory, whichever is smaller.

    List of all properties of a textbox:

    https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.controls.textbox_properties.aspx

    Tuesday, September 29, 2015 4:19 PM