+ Reply to Thread
Results 1 to 6 of 6

Stock management using barcode scanner, Excel, and VBA

  1. #1
    Registered User
    Join Date
    12-16-2020
    Location
    England
    MS-Off Ver
    2017
    Posts
    1

    Stock management using barcode scanner, Excel, and VBA

    Hi everyone,
    I'm trying to create an Excel sheet, using the newest Office 365 version, to list and manage the stock level of consumables used at my company. The idea is that all items are listed in a sheet, with a numerical code for each item, and the current stock level. The code for each item will be printed as a barcode on the shelf with the item in the store room, when an item is taken from stores the barcode is scanned and this will automatically reduce the current stock level value of this item by 1.

    The process seems relatively simple but I have no experience in using VBA and I've already promised my new boss I can make it work, so now is the perfect time to learn how to do it. The Excel sheet with the list on is already created and so it is just the implementation of the barcode I need to work on. Does anyone have any advice or places I can look to find a way to make this work? thank you for taking the time to read this and thanks in advance for any help you can give me.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,550

    Re: Stock management using barcode scanner, Excel, and VBA

    .
    Do a search on this forum using the terms : bar code inventory

    The basic search field is located in the upper right corner.

    There are a number of excellent past threads with discussion and sample files. Those should get you started, very well, in the right direction.

  3. #3
    Registered User
    Join Date
    02-23-2019
    Location
    thailand
    MS-Off Ver
    2013
    Posts
    1

    Re: Stock management using barcode scanner, Excel, and VBA

    I'm doing at now. It's so hard haha. I stuck in setfocus not work. ToT

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Re: Stock management using barcode scanner, Excel, and VBA

    This will give you an idea...Very basic example...
    I made use of "Free 3 of 9 Extended" Barcode Font...For Col C
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 12-21-2020 at 05:38 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  5. #5
    Registered User
    Join Date
    04-09-2021
    Location
    Ryssland
    MS-Off Ver
    1
    Posts
    1

    Re: Stock management using barcode scanner, Excel, and VBA

    Hello, im really new to this (VBA) and dont understand much of it but i found your template really handy. one question, at the moment it only works as long as the SKU# is consisting of only numbers? is it possible to change this so i can use barrcodes that use letters as well? Lke X0019EQQ... etc? Thanks a lot!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,497

    Re: Stock management using barcode scanner, Excel, and VBA

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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. setting up an inventory management system with barcode scanner
    By Driekant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2019, 05:13 AM
  2. Stock count using barcode scanner
    By Matt141980 in forum Excel General
    Replies: 3
    Last Post: 11-07-2018, 05:33 PM
  3. [SOLVED] Barcode scanner to Excel
    By codrinelu in forum Excel General
    Replies: 47
    Last Post: 05-17-2016, 11:06 AM
  4. Using a barcode scanner with excel
    By Fred45 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2013, 09:23 AM
  5. Barcode scanner in excel
    By amir8000 in forum Excel General
    Replies: 1
    Last Post: 06-03-2013, 08:30 PM
  6. Interfacing MS Excel with a BarCode Scanner
    By Big Jake in forum Excel General
    Replies: 1
    Last Post: 08-02-2009, 05:11 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