How to create barcodes in Excel that WORK!

Get ready to dive into a unique Excel project: creating UPC-A barcodes! This video is perfect for those who love to explore unconventional uses of Excel. Discover how to generate these common 12-digit barcodes right in your spreadsheet, complete with a detailed explanation and a touch of VBA magic.

✨ Key Highlights:
▪️ Understanding UPC-A Barcodes: Learn what UPC-A barcodes are and their components.
▪️ Step-by-Step Guide: Follow a detailed guide to create UPC-A barcodes in Excel.
▪️ Using VBA for Barcode Generation: Uncover how VBA (Visual Basic for Applications) is used to automate barcode creation.
▪️ Practical Example: Test the barcode creation with a real product to ensure accuracy.
▪️ Downloadable Resource: Access a ready-to-use Excel file for creating your own barcodes.

You can download the Excel file and use it to generate your own barcode or use it to learn Excel (thank you Pete for sharing).

The solution is a good mix of Excel formulas such as the MOD function, Excel Text functions like LEFT, RIGHT & MID functions as well as Conditional formatting and some Excel VBA. The final result, i.e. the Excel barcode is recognized by the barcode scanner.

Thank you Pete for sharing this awesome barcode tool with us!

00:00 Why Barcodes in Excel?
01:03 How It Works
05:16 How to Setup a Barcode Generator in Excel

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[karhukivi]

I never cease to be amazed at what Excel can do and how well you explain these features - thank you, Leila!

[kennethlee]

You're the best teacher when it comes to Excel, Leila. Thanks for sharing all these wonderful Excel tips! :)

[justanotherexmo]

I accomplished this by creating my own barcode font that I drew myself in a font creator. I drew a set of characters for the category, manufacturer, product and check digit. I used VBA to do the calculations and for the font output I used offset ascii characters in the map so that each region had its own 10 digit section. I also drew generic bars for inside and outside braces. Fortunately the VBA structure works well as I drew these about 15 years ago and it has performed in all versions of Excel. I am a price book manager for a company with 80 stores and this is used for generating order guides, shelf tags and waste logs.

[PhenomenalChezline]

Leila, when I came here, I wasn't expecting this level of detail but you really wowed me. I couldn't stop watching and learning. Awesome channel. Keep creating great content!

[BillHester]

Ha ha ha "High fructose corn syrup, that's the first ingredient. Doesn't sound so healthy but I already finished it."
Leila I am so glad I subscribed to your channel... So intuitive, so easy to listen to and absorb; those hilarious comments are just icing on the cake.

[ismailismaili]

thank you so much Ms. Leila and Mr. Pete it was really useful and great video to watch I really appreciate.

[andypuempel]

Nicely done. Always enjoy seeing creative uses of the powerful capabilities of Excel. Your videos are always to the point and well produced.

[Hey_Delight]

Another precious learnimg tool.
Thanks so much Ms. Leila and Sir Pete.
❤❤❤

[dennisd]

Thank you for sharing Pete's code and making it understandable. I learn so such from your videos.

[aspalding]

Leila, you are such a charmer. I have always wondered about how barcodes worked and how to create them. Your simple, clear and detailed explanation did not miss it's mark! You must be an amazing person, thank you so much))

[hasarangaanuradha]

This is super stuff, Leila. I learned a lot from your youtube lessons - Thank you.

[Bens]

It came on my recommendation, I went all ears!!

[johnboyd]

Hi Leila, over 10 years ago I made a barcode generator in Excel 2010 without using VBA. I used it for years in the company I worked for - it worked perfectly.

Love your videos, there is always something to learn even though I'm in my 70s.

[victortomno]

Dear Leila, you have done a wonderful job in showing us that it is possible to generate a barcode by use of Excel. I have also tried to prepare one like that, I only stopped at the point where you needed to link with VBA array.

[arounaalaho]

Leila you are among the bests ever. Thank you for sharing important stuff here!

[alicogurcu]

Thank you very much for this great video.
I wonder can we use this function to write delivery note info that each reference and quantity then we read each barcode with barcode reader and so we transfer this delivery note to our computer.
Is this possible?

[AngeloHafner]

Your videos are fabulous. You transmit knowledge of high complexity in a simple way. Thank you!

[akshaygarg]

Nice to see that this is possible in excel, as we all know there are multiple ways tof doing same thing excel, this can be done by using V lookup function also as in that way we dont need to run any of the macro

[JeremyMcMahan]

As an exercise I just did this in formulas without VBA using a left and right lookup table and VLOOKUP. Works like a champ! Thanks again Leila for the fun video!

[ExcelForFreelancers]

Great video Leila, I learned a lot. :)