+ Reply to Thread
Results 1 to 6 of 6

Force user to enter specific alphabets in userform

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    11

    Force user to enter specific alphabets in userform

    hi excel experts
    I have a userform where a textbox is used to input the aplphabetic code name of a Raw material. The first two alphabets to be used in the textbox are 'R' & 'X' respectively. After typing in 'RX' the user can type in any other alphabets. My problem is how to force the user to type R & X first before entering other alphabets? Any clue friends...... Thanking you in advance

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Force user to enter specific alphabets in userform

    Please Login or Register  to view this content.

  3. #3
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Force user to enter specific alphabets in userform

    Put this code in the userform on the textbox code :

    Please Login or Register  to view this content.
    Please click on the * below if this helps
    Please click the * below if this helps

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Force user to enter specific alphabets in userform

    Saji,

    Just to be clear, JasperD's code would at "RX" to the beginning of whatever your user inputs into textbox1 IF they haven't entered it themself.

  5. #5
    Registered User
    Join Date
    03-26-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Force user to enter specific alphabets in userform

    Thank you JasperD. That solved my problem

  6. #6
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Force user to enter specific alphabets in userform

    Please mark the thread as solved

+ 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