+ Reply to Thread
Results 1 to 24 of 24

How to check postal code format for user form text box

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: How to check postal code format for user form text box

    Change
    ws.Cells(iRow, 1).Value = txt_PC.Value
    to
        ws.Cells(iRow, 1).Value = Left$(Replace$(Me.txt_PC.Value, " ", ""), 3) & _
            " " & Mid$(Replace$(Me.txt_PC.Value, " ", ""), 4)

  2. #2
    Registered User
    Join Date
    02-27-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: How to check postal code format for user form text box

    Thank you so much Jindon for all your help and patience! I've learned so much! Hope others will see this as valuable as I did!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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