+ Reply to Thread
Results 1 to 6 of 6

Barcode Scanner Inventory With Count Exceeds the Approved Qty

  1. #1
    Registered User
    Join Date
    02-15-2021
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    4

    Post Barcode Scanner Inventory With Count Exceeds the Approved Qty

    Hi
    I Would like to thanks all you guys, first Because i have made this file/Code From your Amazing Help, i have this Workbook Coded to find the Value Entered by barcode scanner and add/deduct from the "E" Col. but i have an Extra Feature if you could help me With it.

    1. I need a Message Appears Once counted Inventory Exceeds the Approved Quantity.
    2. Once Reached the Approved Qty it cannot Add More Qty, but it can be Deducted.
    Explanation:
    The Person will Scan the Barcode in the Cell "B1", it Will search within the Range A,B,C until the End of Entries, and then Increase the Number in "E" (Count), What i need is Reject any Value Greater than the Approved Qty "F", Once scanned and the Value will be Over Approved Qty then Reject the Entry and Display Message to the User.


    And if that Possible you could Comment the Steps for my Reference
    Please Login or Register  to view this content.
    I don't know why the Attachment System not working with me, but maybe the Screenshot will help somehow, i will try to attach the file once reached home maybe from Office PC is now allowing me to attach or anything
    Capture.PNG


    Thanks and Regards
    M Habib
    Attached Files Attached Files
    Last edited by mohmadhabib; 08-02-2021 at 09:43 AM. Reason: Add Attachment

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    907

    Re: Barcode Scanner Inventory With Count Exceeds the Approved Qty

    Add these four lines of code to this part of your macro:
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,158

    Re: Barcode Scanner Inventory With Count Exceeds the Approved Qty

    Or
    Please Login or Register  to view this content.
    Artik

  4. #4
    Registered User
    Join Date
    02-15-2021
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Barcode Scanner Inventory With Count Exceeds the Approved Qty

    So many Thanks guys i have Tested both Solutions and it's Working as Well, but just a Little more Question
    Is there any way to move to the scanned item? and how to Lock the Column "E" From Manual Editing Except the User Enter Specific Password?
    In Details:
    After the Scanner reads the number it will increase or Decrease the Qty in Column "E", the Cell increased Decreased Will be Highlighted or Selected

  5. #5
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,158

    Re: Barcode Scanner Inventory With Count Exceeds the Approved Qty

    You've probably unlocked the E6:E9 range to make your macro work. But it needs to be done a little differently.
    1. Lock the range E6:E9
    2. Unlock B1:C2
    3. Correct the procedure for the following (define your password in the code):
    Please Login or Register  to view this content.
    AND in standard module (eg. Module1):
    Please Login or Register  to view this content.
    After the subtraction or addition, the row with the changed cell appears first. In addition, the cell will change color for two seconds. You can apply both solutions or choose one of them by modifying the code yourself.

    Artik

  6. #6
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    907

    Re: Barcode Scanner Inventory With Count Exceeds the Approved Qty

    Since I have already given a solution maybe it's better if I too give my version to the request. Beforehand it is necessary to Unlock all cells of the sheet and then Lock once again the cells in column E from row 6 to end downwards (this part is obvious ).
    Please Login or Register  to view this content.

+ 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. Excel Inventory using a barcode scanner (VBA Macros)
    By oscartm4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2021, 05:42 PM
  2. Help Setting Up Inventory Sheet to be used with a Barcode Scanner
    By atmclaurin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2020, 10:14 AM
  3. [SOLVED] Inventory Mangement - Barcode Scanner
    By NewYears1978 in forum Excel General
    Replies: 13
    Last Post: 09-30-2020, 12:57 AM
  4. Adding/Subtracting inventory count using barcode scanner
    By thedon255 in forum Excel General
    Replies: 0
    Last Post: 03-09-2020, 12:30 PM
  5. Replies: 0
    Last Post: 03-17-2017, 10:52 AM
  6. 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
  7. 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

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