+ Reply to Thread
Results 1 to 10 of 10

Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

  1. #1
    Registered User
    Join Date
    08-20-2018
    Location
    Wisconsin
    MS-Off Ver
    Office 356 ProPlus
    Posts
    6

    Exclamation Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    Thanks Guys!
    Attached Images Attached Images
    Last edited by gds3781; 08-23-2018 at 12:42 PM.

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

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    Hello gds3781,

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    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
    Registered User
    Join Date
    08-20-2018
    Location
    Wisconsin
    MS-Off Ver
    Office 356 ProPlus
    Posts
    6

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    Hopefully This will Help!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-20-2018
    Location
    Wisconsin
    MS-Off Ver
    Office 356 ProPlus
    Posts
    6

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    Hopefully this will help!
    Attached Files Attached Files

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,249

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    This might get you started.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  6. #6
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    Please Login or Register  to view this content.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  7. #7
    Registered User
    Join Date
    08-20-2018
    Location
    Wisconsin
    MS-Off Ver
    Office 356 ProPlus
    Posts
    6

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    This worked perfectly! one more question when i try to add an item with one of the comboboxes empty. it gives me an error type 13 how do i change that so it says something like "Please make sure all of the fields are full" and theres no debug button at the bottom?

  8. #8
    Registered User
    Join Date
    08-20-2018
    Location
    Wisconsin
    MS-Off Ver
    Office 356 ProPlus
    Posts
    6

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    Quote Originally Posted by bakerman2 View Post
    This might get you started.
    Please Login or Register  to view this content.
    This worked perfectly! one more question when i try to add an item with one of the comboboxes empty. it gives me an error type 13 how do i change that so it says something like "Please make sure all of the fields are full" and theres no debug button at the bottom?

  9. #9
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,249

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    This should do it.
    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    08-20-2018
    Location
    Wisconsin
    MS-Off Ver
    Office 356 ProPlus
    Posts
    6

    Re: Adding or Subtracting a Quantity of 1 from an Inventory using Command Buttons

    cheers mate!
    i figured out through videos this bit of code
    Please Login or Register  to view this content.
    but i like yours better

+ 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. Sumif and Sumifs Subtracting quantity twice
    By RJK in forum Excel General
    Replies: 3
    Last Post: 02-02-2017, 02:36 PM
  2. Update inventory worksheet by adding/subtracting stock with the quantity.
    By august20 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2015, 03:46 AM
  3. adding/subtracting inventory between the sheets
    By non-pro in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-07-2013, 05:27 PM
  4. Useform Code - 12 Command Buttons dependant on other command buttons
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 10:58 AM
  5. Macro Buttons for Editing and Adding Inventory
    By Philrulesw in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-10-2012, 06:26 PM
  6. Adding and Subtracting quantity to an inventory list
    By theJARRETconcept in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-09-2011, 12:43 PM
  7. adding userform command buttons
    By borg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2006, 12:15 PM

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