+ Reply to Thread
Results 1 to 3 of 3

Add 1 to the last number in a textbox in a userform

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Add 1 to the last number in a textbox in a userform

    I want to add a 1 to the last number in a textbox in a userform. I can add a 1 to the last number if the last number is less then one:

    ex. popcans 1
    popcans 2
    popcans 3

    Once the number gets to 19 it adds a 1 to the 9 and the number becomes 110 (1 & (9+1) = 110)

    I want the last number to increase by 1 regardless of the number (5, 15, 19, 29, etc.)

    Can someone help me?

  2. #2
    Forum Contributor
    Join Date
    01-25-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2016
    Posts
    166

    Re: Add 1 to the last number in a textbox in a userform

    This will do it but you will have to change the "temp" variable to whatever you textbox variable is.

    Please Login or Register  to view this content.
    Last edited by tom.hogan; 05-06-2014 at 12:44 PM.
    Tom

    If my answer resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post
    .

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Re: Add 1 to the last number in a textbox in a userform

    Thanks Tom! Works Great!

+ 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. how to generate serial number on a textbox in userform
    By minionrush in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 05:12 AM
  2. [SOLVED] Insert a number of rows according to textbox on userform
    By hoimae in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-16-2012, 09:59 AM
  3. Index number for controls (eg Textbox) in userform
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2010, 08:46 AM
  4. adding consecutive number to userform textbox
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-10-2008, 09:04 AM
  5. Userform textbox number formats
    By PhilM in forum Excel General
    Replies: 2
    Last Post: 06-07-2006, 06:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1