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!
3.6 (12 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,523 students enrolled
$40
Take This Course
  • Lectures 21
  • Contents Video: 2 hours
    Other: 0 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2014 English

Course 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!

What are the requirements?

  • Computer
  • Microsoft Excel
  • Eventually get a Barcode scanner

What am I going to get from this course?

  • 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

What is the target audience?

  • Programmers
  • IT Workers
  • Excel Users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started - An Introduction to Barcoding
01: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 Materials
Article
01: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

06: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.

07: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.

Section 2: Getting Set Up. . .
02: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.

04: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.

08: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!

04: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.

01:45

A final review of all Label sheet macros included in the course.

Section 3: Creating Our First Program
04: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!

11:22

Still working on our userform, we add a bit of spice to automate data entry using barcode scanner.

06: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.

Section 4: Alternate Methods
12: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!

11: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.

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!

10: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!

Section 5: FINAL TIPS
04: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!

04: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!

01:07

Nothing's worse than a bad scan. Check out Dan's final tips on getting that scan PERFECT! A stitch in time. . .

01: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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Daniel Strong, Excel Instructor/Programmer

Hi! My name is Daniel and i'm 29. I've lived most my life in Scott City, Missouri, United States. I've been using Excel since my early teens, and very early on realized that I absolutely love it. After working on various projects in my spare time for years, improving the lives of those that used my programs, I knew this was more than just a hobby for me; it's my passion. A few years back, I got my first opportunity to program in Excel, but when I landed the job I was asked to re-write my predecessor's coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! I studied and studied what I could online and in books, but I wasn't able to learn much that way. I had to dive into my first project for months and months - basically just teaching myself and "figuring it out". I realized that if only someone was out there teaching Excel VBA like Mike Gervin (ExcelIsFun) taught Excel, making everything simple and visual - then Anyone could learn VBA! I started a YouTube channel, mostly for myself as a reference tool, but people started to bite. People flooded my inbox with questions and comments that I was literally changing their lives for the better. My passion is and always has been teaching, and I've turned thousands of people into Excel programmers. Now, with Udemy, I'm going to teach the good stuff - the stuff I kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.

Ready to start learning?
Take This Course