Excel VBA for Business: Barcodes

Excel VBA guide to make your own Excel VBA Programs to simplify your life using Barcodes! Step by step inventory system!

Created byDaniel Strong

Last updated 3/2021

English

What you'll learn

Learn to Create and Customize your own Barcode Labels
Comprehensive understanding of Successful Barcode Scanning and Labeling
Build your own custom Inventory System with Step-By-Step video instructions

Course content

5 sections • 24 lectures • 2h 17m total length

Introduction1:45
As a programmer, we're all about making life easier for the user. In this lesson, we'll discover why barcodes are significant in several different industries and how we can use them to automate data entry and eliminate errors.
Course Materials0:06
A Note on Barcode Fonts1:43
Some barcode fonts are FREE, but very few of the free fonts will actually do you any good without depending on an online source. We want to be able to generate our own barcodes in Excel, so I'm going to let you in on a secret font that works everytime and is legible by almost ALL barcode scanners. This is a free-to-the-public font and it's included in the course downloads. You can also get paid fonts on the web if you have more specific needs.

The website listed in this video is http://grandzebu.net/informatique/codbar-en/code128.htm
Installing the Fonts2:03
In this lesson, Dan will shows you how to install the barcode font that's included in the course, so that the programming code will look like a barcode and not jibberish.
How to Use the Program to Print Barcode Labels6:40
In this lesson, Dan will show you how to use his Excel workbook (included FREE in this course) in order to Generate and Print various Avery label sheets sized labels. You can also customize the sheets and create your own to suit your own needs. We'll show you how the code works and how to generate your own report-label sheets in future lessons.
Technical Demo and Tips on Getting a Good Scan7:20
Learn how a scanner works and how easy it is to get a good scan when you know the ins and outs. In this lesson, Dan shows you what it looks like to scan to a computer using a USB wired barcode scanner. We'll begin by scanning to Microsoft Word.

Using the Special Function and Font in Excel4:20
This lesson is a technical walkthrough of how we use the UDF (user defined function) included in order to generate the code in each cell that we need a barcode.
BONUS Font and Function - Free 3 of 9 Extended2:52
How the Label Sheets Work in VBA and Demo of Printing8:13
In this lesson, we'll show you how to use the Colored buttons that generate each report and how the code works behind it. Simply select your group of cells, click one of the buttons and voila! Your printer is now printing your barcode labels!! Check it out!
Best Labels to Buy4:37
In this lesson, we review Avery brand, Staples brand labels and talk about sizes and adhesize qualities for your labels. We'll also reveal a special catch-all style of labels that Dan uses as his secret weapon when he can't find a match.
Review Other Macros Included in Project Workbook1:45
A final review of all Label sheet macros included in the course.

Creating Our First Userform4:24
Now we get to some exciting ground - Creating our first scanning program. Follow along as Dan leads you into creating a barcode-intensive program for scanning items into an inventory system!
Automating Data Entry11:22
Still working on our userform, we add a bit of spice to automate data entry using barcode scanner.
Practical Application Exercise6:49
Let's test our first Userform with the scanner! In this lesson, Dan takes some file folders with Barcodes and scans them in using the Barcodes on the filing racks to categorize them into inventory.

Dealing With Non-Uniform Scan Lengths12:52
Sometimes you'll have barcodes with the same number of characters - Sometimes NOT! In this lesson, we review an alternate method of recognition for the program. We use a special Character that tells the program when to begin looking up the item in question. Check it out!
Looking Up Inventoried Items as You Scan11:46
Each time we scan, we'll need to look to see if this is a duplicate AND to find out where this item is located or to whom it is assigned.
Marking Items as Shipped or "Finished"15:42
We've scanned the items into the database. Now what?! In this lesson, we're leaping forward in time to when it's time to Ship the items off (aka take them out of inventory) and mark them as shipped or "Finished Project", depending on what industry. Check it out!
Adding Labels to Userform to Track Inventory Easily10:06
Tired of guessing how many items we just scanned? How many are left? We're going to add some informative labels and a macro that triggers them to update for each scan. Follow along!
Adding Multiple Fields from a Single Scan11:24

Getting A Proper Scan (and Troubleshooting Bad Scans)4:50
Nothing's worse than setting up hundreds (or more) of barcodes, just to find that your labels aren't sticky enough due to environmental factors or adhesives, OR that your scanners won't reach that far or your labels aren't big enough. Maybe it's smudgy?! Follow these tips to get a great scan everytime!
Scanner Units - Symbologies, Scan Range, Price and Durability4:47
In this lesson, Dan gives tips on what questions to ask a vendor when finding the right scanner for you. What symbols do I need it to read? How far can I get before it won't read anymore, pricing and ruggedization talks as well. Check it out!
More Tips on Getting a Proper Scan1:07
Nothing's worse than a bad scan. Check out Dan's final tips on getting that scan PERFECT! A stitch in time. . .
Conclusion1:21
A Big Fat Thank you for subscribing to this course and Dan's concluding thoughts. To your continued success!

Dan Strong

More resources to help you learn and grow in your art @

www.ExcelVbaIsFun.com

www.youtube.com/ExcelVbaIsFun
BONUS LECTURE0:03

Requirements

Computer
Microsoft Excel
Eventually get a Barcode scanner

Description

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, Everytime!
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

****** See what others are saying ******

"Just finished Dan's course. He has a wealth of knowledge with Excel VBA and applies simple yet thought provoking ways to apply barcode scanning and tracking methods. This course was designed to benefit Excel beginners to advanced users. Also Dan's approach to solving problems during his lectures displays his confidence of this subject matter. Take this course if you are interested in extending your knowledge of Excel VBA. ExcelVBA IS Fun!" - Kevin Nee

"Hi Dan, After watching all of the videos I can defiantly see us using this for our company. We currently depend on pencil and paper and the honor system for tracking labor hours for jobs. Each employee is responsible for tracking the hours they spend on a given job. We could print a barcode for each job and apply the label to a board or something like that. Then when an employee starts on that job they would scan that label then select their name. Then the program would stamp the start time, when they are done they scan the bar code again select their name and the program would stamp the stop time. I will defiantly continue studying this course and look into coming up with something of this nature for our company. Thanks for the course." -Scott

"Really awesom course!! Thank you!!!!" -Eunicer R.

You'll receive all these benefits:

Included in the course are 20+ Video Lectures describing the process as well as hands on technical demonstrations for all course materials We provided you with everything you need to get started Today with your Barcode Excel VBA program - Font & How to use them properly, Workbook and how to use it.

Subscription to this course entitles you to LIFETIME Video and Attachments updates, and we will add more material along the way.

Check it out!

Who this course is for:

Programmers
IT Workers
Excel Users

Excel VBA for Business: Barcodes

What you'll learn

Explore related topics

Course content

Getting Started - An Introduction to Barcoding6 lectures • 20min

Getting Set Up. . .5 lectures • 22min

Creating Our First Program3 lectures • 23min

Alternate Methods5 lectures • 1hr 2min

FINAL TIPS5 lectures • 12min

Requirements

Description

Who this course is for: