+ Reply to Thread
Results 1 to 2 of 2

Copy a part of a text from textbox1 to textbox 2.

  1. #1
    Registered User
    Join Date
    07-31-2016
    Location
    Holland
    MS-Off Ver
    2011
    Posts
    57

    Copy a part of a text from textbox1 to textbox 2.

    Hi All,

    Learning, but still a rooky.

    Is there a way to copy a part of a text from textbox1 to textbox 2.

    Textbox 1 can contain different values, in all combination I need to copy the part after the first space if the characters are numerals, until the next space or not numeral.

    77788R 88874KLM needs to copy 88874
    5552 8885452 10F needs to copy 8885452
    etc.

    Hope someone can help.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    377

    Re: Copy a part of a text from textbox1 to textbox 2.

    You could use a RegEx pattern to strip the part of the code you need out.

    Please Login or Register  to view this content.

+ 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. Textbox1 userform to textbox sheet
    By Jurgenp in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2020, 08:54 AM
  2. [SOLVED] How to make autofill textbox based on value in textbox1?
    By meloception in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2017, 02:44 AM
  3. Clear contents from textbox1 and 2 when i click in textbox 3
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-15-2017, 01:25 PM
  4. How to move the textbox cursor from textbox1 to textbox2 using the arrow key?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2014, 05:14 AM
  5. If textbox1 is empty then put paste some default text to textbox1
    By vijaynadiad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 03:16 PM
  6. [SOLVED] while use enters text in textbox1 I want the textbox to auto compl
    By Jim at Eagle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2010, 03:01 PM
  7. [SOLVED] Selecting part text in a textbox
    By vqthomf in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2005, 10:05 AM

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