+ Reply to Thread
Results 1 to 2 of 2

Code for a Texbox Item for input of Purchase Orders

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    7

    Code for a Texbox Item for input of Purchase Orders

    I have just started picking up VBA and I am using Excel 2007. I am creatin g a UserForm that has multiple textboxes for data input. One I am having trouble with, is verifying that the input to the Purchase Order textbox is correct. I am wanting the user to input a PO in the format of "JK 12345" -> Two Letters followed by a space then Five Numbers. Does anyone know how this may be done? Thanks 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: Code for a Texbox Item for input of Purchase Orders

    If TextBoxN like "[A-Z][A-Z] [0-9][0-9][0-9][0-9][0-9]" then finish code...

+ 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