Excel VBA Projects: Simple Inventory
System with Barcodes

Create A Simple Inventory Program With Excel VBA And Barcodes


Great news! You already have access to this course! 👇






Skill Level




Speed up productivity and lower data entry errors!

It’s no secret that data entry errors can cause big problems. Fortunately, this course provides you with a complete set of skills to help you create programs in Excel. This course provides over 2 jam-packed hours of tutorials, including:

  • Data entry with barcodes
  • Barcode scan to look-up items from your worksheet/databases
  • How to auto-move screens during or after a scan
  • How to process barcodes with random lengths
  • Lots of tips for creating and getting a good scan, every time!
  • Free companion workbook with real life examples
  • Free macros and buttons to generate avery 5160, 5162, 5163 and Large label sheets – PLUS Unlimited space for your custom sized projects
  • And a lot more...

Check it out now!

What's Included In The Course

We provided you with everything you need to get started Today with your Barcode Excel VBA program!


FREE Companion workbook with real life examples as well as to how to use them properly


20+ Video Lectures describing the process as well as hands on technical demonstrations for all course materials


To generate avery 5160, 5162, 5163 and large label sheets - plus unlimited space for your custom sized projects


Subscription to this course entitles you to lifetime video and attachments updates, and we will add more material along the way


  • Introduction
  • A Note On Barcode Fonts
  • Installing The Fonts
  • How To Use The Program To Print Barcode Labels
  • Technical Demo & Tips On Getting A Good Scan

Video: 20 minutes, 6 lectures   

  • Using The Special Function And Font In Excel
  • Bonus Font And Function - Free 3 Of 9 Extended
  • How The Label Sheets Work In VBA & Demo Of Printing
  • Best Labels To Buy
  • Review Other Macros Included In Project Workbook

Video: 22 minutes, 5 lectures   

  • Creating Our First UserForm
  • Automating Data Entry
  • Practical Application Exercise

Video: 23 minutes, 3 lectures   

  • Dealing With Non-Uniform Scan Lengths
  • Looking Up Inventoried Items As You Scan
  • Marking Items As Shipped Or "Finished"
  • Adding Labels To UserForm To Track Inventory Easily
  • Adding Multiple Fields From A Single Scan

Video: 1 hour & 2 minutes, 5 lectures

  • Getting A Proper Scan (and Troubleshooting Bad Scans)
  • Scanner Units - Symbologies, Scan Range, Price And Durability
  • More Tips On Getting A Proper Scan
  • Conclusion
  • Bonus Lecture

Video: 12 minutes, 5 lectures   


This course is for anyone but this is more beneficial to Programmers, IT Workers and Excel users.


Speed Up Productivity !

What Students Say About The Course



We are confident that our course will provide you with immense value and help you achieve your goals. To demonstrate our commitment to your satisfaction, we offer a 30-day money back guarantee. If for any reason you are not completely satisfied with the course within 30 days of your purchase, simply contact our customer support team, and we will refund your full payment. No questions asked! 

Frequently Asked Questions

  • Microsoft Excel
  • Eventually get a Barcode scanner
  • The course will start right away upon signing up, you get instant access.

How would you like access to ALL our Excel courses?

  • Excel Ninja Pro is a subscription streaming service that offers a wide variety of Excel resources, including premium online courses, code vault, swipe files, downloadable workbooks, projects, events, and a results-driven community of Automators.

  • You can watch as much as you want, commercial free - all for one low monthly price. There's always something new coming soon and Ninja Pro members get to help decide what comes next!

Learn more HERE.

Visit the My Courses link at the top left of the site menu. You can also visit the Member's Area and click on Courses tab.

NOTE: You should have an email with a username and link to reset password initially. If not, please check spam folder (if none, contact us immediately or see "How do I change/update my password?" above).

  • Today’s World is full of busy people that want to better themselves, so self-paced programs are popular. Yes, you can learn at your own speed, so that you can focus on things that you find challenging and breeze past things that you already know. You will be the one to decide when to start accessing the course materials and when to finish.
  • Yes, definitely! If you have questions about the lesson, we will answer all your questions as soon as possible.
  • Does lifetime access sounds good to you? You'll have unlimited access to the course once you've enrolled. This means you can re-watch lessons whenever you need and complete the course at your own pace.

Every course in the member's area comes with a 'Certificate of Completion' that you can add to your LinkedIn bio, to your resume or even brag to your friends.

You also get achievement badges the more you participate, comment, and share with the group. You can check out our achievement’s dashboard!

© 2024 – Strong Software Solutions LLC | ExcelVbaIsFun – Privacy PolicyTerms and Conditions
This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way.

FACEBOOK is a trademark of FACEBOOK, Inc.

Forgot Password?

Join Us

    Your Cart
    Your cart is emptyReturn to Shop