+ Reply to Thread
Results 1 to 3 of 3

Text box restriction

  1. #1
    Registered User
    Join Date
    10-06-2013
    Location
    Cyprus
    MS-Off Ver
    Excel 2007
    Posts
    3

    Text box restriction

    Hello All,

    I have a text box on a user form where I want to restrict the input to 9 characters, the first 8 should be numbers and only the last one to be a capital letter. Can this be done using a macro code?

    Thanks

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Text box restriction

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    10-06-2013
    Location
    Cyprus
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Text box restriction

    Quote Originally Posted by AlphaFrog View Post
    Try this...

    Please Login or Register  to view this content.
    It works just fine. Thanks for your input!!!

+ 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. GetOpenFilename restriction
    By julhs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2013, 03:40 PM
  2. Restriction Message
    By VETcalc in forum Excel General
    Replies: 5
    Last Post: 09-21-2012, 03:45 PM
  3. Excel 2007 : Nested IF restriction of 7
    By z3tls0 in forum Excel General
    Replies: 9
    Last Post: 11-23-2010, 07:18 PM
  4. Restriction on IF statement
    By Guitarga in forum Excel General
    Replies: 8
    Last Post: 06-20-2010, 06:07 PM
  5. User restriction
    By Bob@Sun in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-06-2010, 02:55 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