+ Reply to Thread
Results 1 to 6 of 6

Automatic Counting

  1. #1
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    157

    Automatic Counting

    Hello everyone,

    i need help again. i have a project for warehousing and i want to
    automatic count the series of issuance (Textbox3) for materials to avoid manual
    inputing of series number.

    if i close the excel the last number cannot change to series number of
    issuance("textbox3")
    Attached Files Attached Files

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,895

    Re: Automatic Counting

    Hello Chandria,

    Could you please show us on two separate Sheets what you have, and on another Sheet the desired outcome. It is a bit confusing with your Textboxes arranged in descending order.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Automatic Counting

    Here's how I would go about it... I would create a hidden Sheet/Row/Column on your excel file and store the number there that way when you open the userform you can have it grab that number from and then store it after its done... I would look at possible setting your user form to auto clear the 2 item text boxes (textbox1, textbox2) to stop users from double posting the same information.
    Attached Files Attached Files
    Bramz

  4. #4
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    157

    Re: Automatic Counting

    Thanks you. Winon

  5. #5
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    157

    Re: Automatic Counting

    Great, Thank you meabrams.
    Please Login or Register  to view this content.
    but when i close the textbox3. value back to "0"
    Thanks again and have a good day.
    Last edited by Chandria; 08-15-2018 at 03:26 AM. Reason: add code

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,895

    Re: Automatic Counting

    Hello Chandria,

    Please use Code Tags when you are posting any Code.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    Regards.

+ 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