+ Reply to Thread
Results 1 to 3 of 3

Inventory deducted userform to affect excel database.

  1. #1
    Registered User
    Join Date
    01-11-2018
    Location
    america
    MS-Off Ver
    2016
    Posts
    2

    Inventory deducted userform to affect excel database.

    Hello, I am seeking help with sending data from a userform in vba to the appropriate cell in excel. (this is for an inventory system I'm making)

    My userform has a text box for Products names and a text box for Quantity to be deducted. Once the user hits the "save" command button I'd like to see the quantity for the product selected be reduced.

    Almost like a reverse Vlookup. It needs to find the product in my database and then I could offset one cell to the right easily.

    Any help would be amazing. thank you for your time

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Inventory deducted userform to affect excel database.

    If this does not do exactly what you want, it will at least have sample code and logic.
    https://www.excelforum.com/tips-and-...y-program.html
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    01-11-2018
    Location
    america
    MS-Off Ver
    2016
    Posts
    2

    Re: Inventory deducted userform to affect excel database.

    Thank you! I’ll take a look and let you know! Many thanks!

+ 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. [SOLVED] Can you affect elements in userform based on a cell value?
    By Memphismark in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2016, 08:42 AM
  2. [SOLVED] Excel Userform Inventory
    By azmir in forum Excel General
    Replies: 1
    Last Post: 04-10-2016, 01:24 AM
  3. Excel Inventory Database
    By krishna2221 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-25-2014, 02:42 AM
  4. Inventory Database
    By ktkreeger in forum Excel General
    Replies: 5
    Last Post: 08-28-2013, 03:43 PM
  5. Excel 2007 : Show the sum of whats deducted
    By oidude in forum Excel General
    Replies: 3
    Last Post: 09-01-2010, 01:14 PM
  6. having a set $ amount be deducted from any given total
    By Colin2u in forum Excel General
    Replies: 2
    Last Post: 08-11-2005, 09:05 AM
  7. [SOLVED] Help with Excel Inventory Database
    By ridgerunner in forum Excel General
    Replies: 5
    Last Post: 03-07-2005, 09:06 AM

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