+ Reply to Thread
Results 1 to 4 of 4

Length of a textbox

  1. #1
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Length of a textbox

    I am trying to get the length of characters in a textbox.

    With a normal string i can say =len(A1) but it will not work with a textbox.

    Help please.

    -Ken

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Length of a textbox

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 11-05-2019 at 06:42 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Length of a textbox

    Please Login or Register  to view this content.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Length of a textbox

    Hey Ken,

    You need to go into VBA to get the length of that text. I'm in the immediate window typing this:

    Please Login or Register  to view this content.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Cut length optimization with multi length stocks and multi length orders
    By badri.rakesh in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-23-2023, 06:50 PM
  2. Autosize textbox shape control based on string length
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2019, 06:55 AM
  3. [SOLVED] Limit Character Length in a Userform Textbox
    By Gal403 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2014, 05:18 AM
  4. [SOLVED] Shorten string length if exceeds 31 characters (max sheet name length)
    By r2fro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2014, 05:57 AM
  5. Repeat Calculation At Length & Calculate Lowest Value At Length
    By sanju2323 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2013, 09:19 AM
  6. Selecting particular length of text and copying in other textbox
    By singoi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2009, 10:00 AM
  7. [SOLVED] Interesting problem with VBA generated textbox (or textframe of shape) length
    By Bill Dilworth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2005, 12:15 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