+ Reply to Thread
Results 1 to 3 of 3

Active Cell Character Count

  1. #1
    Registered User
    Join Date
    07-01-2004
    Posts
    21

    Active Cell Character Count

    Is there a way to display an active cell character count while the user is typing in a cell? I have limited a cell to 100 characters and would like to let the user know how close they are to the limit while they are typing.

    Thanks.
    JoJo

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello JoJo,

    There is no built-in function in Excel to do that, and constructing a macro to do so would a very complicated task. Your users will just have to type until they stop typing or the cell Validation stops them.

    Sincerely,
    Leith Ross

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    This is how I would do it. Create a userform (showmodal=False). In this userform you have two textboxes and one label. The textboxes are small and covered by the label.

    In the userform code sheet
    Please Login or Register  to view this content.
    In the code sheet for the worksheet
    Please Login or Register  to view this content.
    When the user selects A1, Textbox1 is filled with the contents of A1. (But he doesn't see it, it's hidden by the label which shows the length of the string.)
    As he types, his typing is reflected in A1, while the only thing he can see is the label, which continues to show the length. When he selects a different cell, the userform goes away. TextBox2 is there only so that when the user entere {Return} or {Tab} or {Enter} the focus has somewhere to go, so the TextBox1_Exit routine will run (Unload Me)

    You'll need to modify the A1 restriction

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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