+ Reply to Thread
Results 1 to 4 of 4

Excel Userform TextBox - Change partial string in textbox with command button

  1. #1
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 2013
    Posts
    332

    Excel Userform TextBox - Change partial string in textbox with command button

    Hello, I am trying to find a way to replace part of a string in a textbox. I have the user enter a job number and I have it verify they have entered the side they are working on which is just 2 choices "-TOP" or "-BOTTOM". So when they work on the same job number, I would like to replace one for the other. If they have this: "98-1002-600-TOP" and are finished, I want to press the button and replace just the -TOP with -BOTTOM. Also work in the opposite way if they start BOTTOM first, then it will change to -TOP. Any ideas on this? Your help is greatly appreciated.

    Here is the code I have for checking the end of the job number.... Now I just need to know how to replace one for the other when I change jobs.

    Please Login or Register  to view this content.
    Last edited by Nu2Java; 05-05-2012 at 09:02 PM.

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 2013
    Posts
    332

    Re: Excel Userform TextBox - Change partial string in textbox with command button

    Anyone ?? Someone ?? Any ideas ??

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,163

    Re: Excel Userform TextBox - Change partial string in textbox with command button

    Do you want to toggle "TOP" and "BTM" ?
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 2013
    Posts
    332

    Re: Excel Userform TextBox - Change partial string in textbox with command button

    Hello jindon .... thank you VERY MUCH!! This works exactly how I need it to. You nailed it, yes I wanted to toggle if it is BTM then change to TOP and if TOP change to BTM. Thanks again for your time and help, much appreciated.

+ 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