+ Reply to Thread
Results 1 to 14 of 14

Inventory Mangement - Barcode Scanner

Hybrid View

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Re: Inventory Mangement - Barcode Scanner

    Got the scanner in and everything works great and as intended..the only thing is I still can't figure out how to remove the individual buttons from inside the command menu (or form or whatever it is called?) to onto the page.

    I attempted it but usually it functions only partly or not properly (me not copying all the right code)

    Attaching my current file.

    Maybe I should make a new topic for that since it is party something else ?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-06-2015
    Location
    FL, United States
    MS-Off Ver
    2013
    Posts
    1

    Re: Inventory Mangement - Barcode Scanner

    This may be a year later, but thanks for the Sheet. I am liking the programming set up and would like to give credit where it is due!

  3. #3
    Registered User
    Join Date
    08-12-2015
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    3

    Re: Inventory Mangement - Barcode Scanner

    Dear sirs,

    Please refer your attachment "Inventory Form.xlsm", can you please modify with below changes
    01. Increment and Decrement inventory item quantity in the quantity cell please can you make it for manual entry
    02. how do it get the report for daily transaction details in 2nd sheet
    03. during the Increment and Decrement inventory item quantity can you add one more line to mention the listed project code as a reference

    reply appreciate your advice and support.

  4. #4
    Registered User
    Join Date
    08-12-2015
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    3

    Re: Inventory Mangement - Barcode Scanner

    Dear sirs,

    Please refer your attachment "Inventory Form.xlsm", can you please modify with below changes
    01. Increment and Decrement inventory item quantity in the quantity cell please can you make it for manual entry
    02. how do it get the report for daily transaction details in 2nd sheet
    03. during the Increment and Decrement inventory item quantity can you add one more line to mention the listed project code as a reference

    reply appreciate your advice and support.

  5. #5
    Registered User
    Join Date
    09-29-2020
    Location
    UNITED STATES
    MS-Off Ver
    10
    Posts
    1

    Re: Inventory Mangement - Barcode Scanner

    Not sure if this needs a new thread but I am curious if this does (or if someone knows how) to setup a spreadsheet so that I can print off a sheet of barcodes and then when I scan one (when I go to use it), it will remove the barcode from the master spreadsheet. Then when I scan it again, it will add it back to the master spreadsheet to be used again. Any help or direction would be appreciated.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Inventory Mangement - Barcode Scanner

    Quote Originally Posted by TBURG10 View Post
    Not sure if this needs a new thread but I am curious if this does (or if someone knows how) to setup a spreadsheet so that I can print off a sheet of barcodes and then when I scan one (when I go to use it), it will remove the barcode from the master spreadsheet. Then when I scan it again, it will add it back to the master spreadsheet to be used again. Any help or direction would be appreciated.
    Yes, you need to start a new thread with your question, please. If you feel it is relevant, you can add a link back to this thread

    Thanks
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Can Excel be used with a barcode scanner to track inventory?
    By polluxtroy12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2013, 09:43 PM
  2. Trying to track inventory using a barcode scanner in Excel
    By ernht38 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 08:16 AM
  3. Replies: 0
    Last Post: 05-24-2013, 02:06 PM
  4. Using a barcode scanner to track inventory with differnent employees
    By singlec2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2012, 09:21 PM
  5. Using a barcode scanner and UPC master sheet for Inventory Control
    By jlucas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2011, 04:03 PM

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