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.
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.
Hello Friend! I know this is an old comment, but if you still have the formula you used for this I would love take a look and learn from it! It would go a long way on a project I am working on.
@@Talaran12 Sure, happy to help. I just don't know how I'm able to get the file to you without the whole world knowing either of our contact details. If you have any ideas, let me know.
so pete shared the workbook to her freely, then she shared with us freely and then she uploaded to youtube and youtube shared us freely and she got all the monetization money from youtube so everyone wins :D such a nice win win situation in data age :) you guys z generrations are so damn lucky to be born recently.
We never asked our parents to bring us in this world... However, I'm thankful to everything as it feels amazing to see soo many solutions to just a particular question!
The entire time I'm listening to your voice, I could not stop thinking about how beautiful it would be waking up to a "good morning, how did you sleep last night?" from you on a daily basis. OMG... You're AWESOME.
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!
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))
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.
I use barcodes in Excel all the time. The difference is mine is a "barcode" font that I down loaded and you have to put an "*" before and after the word/number. So my formula is very very simple. ="*"&A1&"*" A1 can be any cell.
Something is weird, I got it to work great, but.. if I click in the cell with your formula, sometimes the formula becomes the barcode , rather than what’s in A1. Any thoughts? Thanks. For your help
Think I speak for many when I say, what we really want is a video of you cooking using the Chipotle Honey Barbecue Sauce recipe. A hearth felt thank you to Pete and yourself on your explanation of bar codes.
Simplest barcode ever: Download Code39 true type font. Install it. Now you have a new font in your programs. Go for example to Excel. Write something in a cell. Create a formula that concatenate an asterisk&what you write&an asterisk (eg.. *hello*) Change the default font in this cell to Code39. Voila! (note: the asterisks tell the scanner where the real text starts and ends). This font is available in any program (excel, powerpoint, word, etc)
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!
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.
Hi Ms. Leila, i am really in a dilema thinking how can i use excel to create barcodes for our internal use to monitor inventory.... Then your video was recommended, i felt like, God thanks for this video...!!!! And im all ears and eyes and is willing to learn this so that i can apply it... Credit also goes to Pete for this outstanding discovery and generosity for sharing this knowledge...😊😊😊
I actually used once bar codes generation in Excel at work - real life situation, valid business case, nothing like doing it just for kicks: the company I worked for used to run their operations on a little bit obsolete software that didn't allow printing multiple labels at once. As long as user needed 1 or 2, it was ok - she/ he could do that manually. No issues with that. However, every once in a while they came across a situation in which 100 or 200 labels had to be printed. Manually that would have been really time-consuming and error-prone (some could have been skipped) process. One simple loop did the trick: generate bar code for whats in A1, print, go to A2, generate bar code, print, repeat. It worked an was for "free" (users had on their laptops Excel installed anyway). I would not underestimate this functionality. I've been watching your clips, your skills in explaining complex ideas is astonishing. Keep doing great job, thank you!
@@casewhite5048 VBA (alt + F11 to open it), you can use few different types of loops: do ... while, do... until and my favourite "for i = 1 to Range("A1").End(xlDown).Row". Google tutorials on VBA loops, you'll find thousands of them
Super video! Thanks a lot. I wanted to create some barcodes for my items with confidential product data For example: I want the barcode to tell me the exact product specifications and pricing details when I scan it However, I dont want anyone else to be able to get the same information This is particularly for exhibitions where we have multiple clients and sometimes it is overwhelming when multiple people come in and need pricing or specs instantly
@@LeilaGharani Haha! Apologies if I sounded patronising, I didn't mean to. I just really love Excel and so spend quite some time playing with it! Perhaps some videos on game programming for those downtime moments? Or maybe that defeats the theme of productivity this channel emanates! :D
Good demo, I actually designed 3of9 barcode generator around 10 years ago for my self and a retail store in Manchester it was quite a powerful program had many features print labels, design a templates even read barcodes and processed stock barcodes too for stock control ect, designed in VB6 its nice to see people still developing source within VBA as most of the coding now is within Python, C# ect -- good job Peter..Nice demo Leila
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
Wow, this is ridiculously simple, I wish I knew about this 10 years back, it would have made a world of difference when I started my job. It's not actually the type of Bar Code we use at my work (Code 128-B), but I imagine that the principals are the same. I think I might make a project out of this video of yours. Thank you soooo much!
At code 128 the biggest problem is to calculate verification last letter of code, but I make it in excel and it works almost 100%. But there are some free barcode generators which are easy to use...
@@001Gastik Yeah, that checksum portion of the barcode was tricky, especially when you had to consider variable lengths of possible barcodes, but I figured it out and it works like a charm.
Glad to know how barcodes are actually generated. Had to admit some part of the video has gone above my head 😂 but i am gonna take another look and also review the worksheet. Thanks Leila and Pete. You guys rock!
I actually used Barcodes in Excel when I scanned files, I used a barcode reader that was linked to my computer, so instead typing the barcode from the folder in the Excel spreadsheet I just scanned it, easy peasy.
During this video my brain could handle learning about how UPC codes are structured. Towards the end though my brain exploded when presented with the VBA array layout.....OMG that is HIGH LEVEL ADVANCED stuff.
Thank you Pete and Leila you have my admiration and respect. Such ingenuity. Leila I know I am but a man but I am totally in love with you. You are a flawless diamond! Now I am going to sign up for one of your VBA courses (hoping there is a basic one) so I can maybe try this myself. Thank you both.
If you only need a few of them, Microsoft Word can create barcodes and QR codes using field codes. That's another kind of learning project, I guess, but it works nicely once you get the hang of it.
I like it. But, I work in a warehouse and make barcodes all day in excel using a barcode font and placing an asterisk in front and rear of the data to scan. No VBA needed. We use code 128 barcodes btw. Always nice to learn a bit more VBA though.
Creating inventory barcodes in Excel - that would be cool! Or barcodes for entry to events - the mind boggles. Just need to know how to get own barcodes recognised by a scanner
I'm wondering how I could use this on some existing data please? For example, I have two columns of information - Name and Part Number. How could I pipe these into this spreadsheet to end up with a third column that had the barcodes for column a & b that I can then print out on a barcode printer?
3 Years ago I created an inventory application in Excel using a cordless barcode scanner to enter stock items AND control Excel (Yes, No, Retry, etc) ... combining it with the "Application.Speech.Speak" in vba the Excel app was able to provide audio feedback to the user. This was important because the stock items and the user's computer were not located in the same part of the office. I printed out a sheet of barcodes from a generic online barcode generator) for various functions such as: item brand, item category, quantity, yes, no, retry, enter, etc. If they scanned the wrong code Excel would say "that is the incorrect barcode, please try again". Once they had scanned all the details for the stock item they scanned ENTER, and Excel would confirm the entry by saying "Item has been entered". Who knew you could completely control Excel with a barcode scanner, huh?
Wow. Looks exactly like something I would do. Recreating the wheel in Excel just because I can! I’ll probably be recreating this as well with a few updated functions (LET for example).
Excel data to barcode labels - you can first enter multiple barcode values in Excel, and then import them into our barcode generator software to make bulk barcode labels, this way can improve the work efficiency.
@@LeilaGharani I'm pretty sure it will be a powerfull tool. Right now I copy/paste the EAN No. (barcode No.)from the manufactor website, into our NAVISION system, which can take ages. So this tool will deffently save time and improve the efficacy. 👍
I do this all the time without VBA Leila. You just need a font (I use 3 of 9 barcode font), and a concatenate formula. I'd be happy to send you a sheet. It couldn't be simpler.
Correct, I managed an entire test article inventory and tracked which parts were used/reused on what test articles using this method, a scanner, and a sticker printer. Much simpler than this method.
@@wackolas there are free fonts available for some barcode types, so you'd type **1234** change the style|font to that barcode font and it will turn into a barcode, like the wingding font. They use typography ligatures to turn a series of characters into another character(barcode)
Thank you Leila. I would like to learn more about UPC Barcodes. For example returning the description, model number etc in different cells of a worksheet after having scanned a UPC of a product. (Using VBA or not)
There are also free barcode generators that have a "url based api" online that you just visit a specific url to generate a barcode image, same thing for QR codes some are also open source so you can setup your own server. Basically set an IMAGE, or hyperlink, formula to contain your types and codes and you get an image back Google sheets example _Barcode,API URL,Type,Value,Image Type, IMAGEFORMULA,barcodegeneratorwexamplewebsite/barcode/,c39,1234567,PNG, _ With the formula for google sheets being =IMAGE(B2&C2&"/"&D2&"."&E2) When the spreadsheet fetches the image it goes to that barcodes specific url and the image gets generated then served to the spreadsheet. The caveat being if you have ALOT of codes that ALOT of images to fetch so can take a bit and some services have rate limits.
OK, agreed that a Barcode font is the way to go, and that a non-VBA solution is available via some lookup creativity However, COVID 19 and isolation, so... My contribution is that it can be solved with a stacked column chart . The first series is set to no fill and just displays the category names, the second series is then stacked on top and forms the barcode. Both series have the column Gap Width set to zero. The result is a barcode as a chart that is a perfect match for the UPC Barcode and is dynamic without code. On a roll, I also achieved just the barcode based on using a Sparkline. If there's interest, I'm happy to release my completed solutions Take care, Stay Safe
It's actually useful if one needs to mock-up bar code symbols for an application without investing in any special software. While there are web sites that will do it for free, one-at-a-time, in a spreadsheet, you could do several. Interesting use of columns to generate the image.
Grab the Excel barcode generator from here 👉 pages.xelplus.com/barcode-generator-file
I never cease to be amazed at what Excel can do and how well you explain these features - thank you, Leila!
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.
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.
Hello Friend! I know this is an old comment, but if you still have the formula you used for this I would love take a look and learn from it! It would go a long way on a project I am working on.
@@Talaran12 Sure, happy to help. I just don't know how I'm able to get the file to you without the whole world knowing either of our contact details. If you have any ideas, let me know.
so pete shared the workbook to her freely, then she shared with us freely and then she uploaded to youtube and youtube shared us freely and she got all the monetization money from youtube so everyone wins :D such a nice win win situation in data age :) you guys z generrations are so damn lucky to be born recently.
We never asked our parents to bring us in this world... However, I'm thankful to everything as it feels amazing to see soo many solutions to just a particular question!
The entire time I'm listening to your voice, I could not stop thinking about how beautiful it would be waking up to a "good morning, how did you sleep last night?" from you on a daily basis. OMG... You're AWESOME.
You're the best teacher when it comes to Excel, Leila. Thanks for sharing all these wonderful Excel tips! :)
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!
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))
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.
I use barcodes in Excel all the time.
The difference is mine is a "barcode" font that I down loaded and you have to put an "*" before and after the word/number.
So my formula is very very simple. ="*"&A1&"*" A1 can be any cell.
Genius. Just what I needed. Thanks
Something is weird, I got it to work great, but.. if I click in the cell with your formula, sometimes the formula becomes the barcode , rather than what’s in A1. Any thoughts? Thanks. For your help
Think I speak for many when I say, what we really want is a video of you cooking using the Chipotle Honey Barbecue Sauce recipe.
A hearth felt thank you to Pete and yourself on your explanation of bar codes.
Fortunately for everyone the bottle is already empty :)
Simplest barcode ever: Download Code39 true type font. Install it. Now you have a new font in your programs. Go for example to Excel. Write something in a cell. Create a formula that concatenate an asterisk&what you write&an asterisk (eg.. *hello*) Change the default font in this cell to Code39. Voila! (note: the asterisks tell the scanner where the real text starts and ends). This font is available in any program (excel, powerpoint, word, etc)
Been doing it that way for 15 years.
But the point was to learn how to use VBA ......
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!
Glad we inspired you to try it your way. This is how real learning happens. Thanks for sharing!
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.
Cool system for American 12 digit codes, great way to see people learning how the check digit is calculated, and not just a random number.
U r the best Teacher Leila, ur style of teaching is marvelous ur accent of talking is very nice as u r nice too. Thanks my Teacher.
Hi Ms. Leila, i am really in a dilema thinking how can i use excel to create barcodes for our internal use to monitor inventory.... Then your video was recommended, i felt like, God thanks for this video...!!!! And im all ears and eyes and is willing to learn this so that i can apply it... Credit also goes to Pete for this outstanding discovery and generosity for sharing this knowledge...😊😊😊
I actually used once bar codes generation in Excel at work - real life situation, valid business case, nothing like doing it just for kicks: the company I worked for used to run their operations on a little bit obsolete software that didn't allow printing multiple labels at once. As long as user needed 1 or 2, it was ok - she/ he could do that manually. No issues with that. However, every once in a while they came across a situation in which 100 or 200 labels had to be printed. Manually that would have been really time-consuming and error-prone (some could have been skipped) process. One simple loop did the trick: generate bar code for whats in A1, print, go to A2, generate bar code, print, repeat. It worked an was for "free" (users had on their laptops Excel installed anyway). I would not underestimate this functionality.
I've been watching your clips, your skills in explaining complex ideas is astonishing. Keep doing great job, thank you!
how did you write the loop script in excel
@@casewhite5048 VBA (alt + F11 to open it), you can use few different types of loops: do ... while, do... until and my favourite "for i = 1 to Range("A1").End(xlDown).Row". Google tutorials on VBA loops, you'll find thousands of them
@@yokerpl thank you
Super video! Thanks a lot.
I wanted to create some barcodes for my items with confidential product data
For example:
I want the barcode to tell me the exact product specifications and pricing details when I scan it
However, I dont want anyone else to be able to get the same information
This is particularly for exhibitions where we have multiple clients and sometimes it is overwhelming when multiple people come in and need pricing or specs instantly
I follow your videos because I love Excel, but this is the first time you've taught me something I didn't already know. Amazing!
Finally! I was almost running out of ideas :)
@@LeilaGharani Haha! Apologies if I sounded patronising, I didn't mean to. I just really love Excel and so spend quite some time playing with it! Perhaps some videos on game programming for those downtime moments? Or maybe that defeats the theme of productivity this channel emanates! :D
Haha, no worries! It's great to have you here. What is a downtime moment :)
@@LeilaGharani Guffaw. You run a tight ship I see
Your videos are fabulous. You transmit knowledge of high complexity in a simple way. Thank you!
Glad you like the videos Angelo!
Leila you are among the bests ever. Thank you for sharing important stuff here!
Thank you for the kind words.
Good demo, I actually designed 3of9 barcode generator around 10 years ago for my self and a retail store in Manchester it was quite a powerful program had many features print labels, design a templates even read barcodes and processed stock barcodes too for stock control ect, designed in VB6 its nice to see people still developing source within VBA as most of the coding now is within Python, C# ect -- good job Peter..Nice demo Leila
Wow, that sounds like a great application.
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
Wow, this is ridiculously simple, I wish I knew about this 10 years back, it would have made a world of difference when I started my job. It's not actually the type of Bar Code we use at my work (Code 128-B), but I imagine that the principals are the same. I think I might make a project out of this video of yours. Thank you soooo much!
yes
At code 128 the biggest problem is to calculate verification last letter of code, but I make it in excel and it works almost 100%. But there are some free barcode generators which are easy to use...
@@001Gastik Yeah, that checksum portion of the barcode was tricky, especially when you had to consider variable lengths of possible barcodes, but I figured it out and it works like a charm.
Glad to know how barcodes are actually generated. Had to admit some part of the video has gone above my head 😂 but i am gonna take another look and also review the worksheet. Thanks Leila and Pete. You guys rock!
It took a while for it to sink in for me too :)
Thank you for sharing such an informative video
My pleasure.
Thank you, Pete! This is excellent! Thank you Leila for the helpful explanation!
Pete is great! Glad you like it.
Very welcome.
Your channel deserves to have a million subscribers and no. 1 trending channel on youtube
Thank you for sharing Pete's code and making it understandable. I learn so such from your videos.
Glad it's useful for you Dennis.
The way you explained is very simple and easy. Thank you
Very Good Tutorial . I like it.
Of course there are a lot of easier apps to generate a barcode. However, the informations and contents of the video are awesome. Thanx!
Thanks for the Guide... Used what was provided as a reference and did it all with only formulas and no VBA.
Awesome Ms. Leila.. very informative
Thank you! 🙂
This cutie pie saved my day ❤️❤️❤️ thankyou very much girl
You’re welcome 😊
I actually used Barcodes in Excel when I scanned files, I used a barcode reader that was linked to my computer, so instead typing the barcode from the folder in the Excel spreadsheet I just scanned it, easy peasy.
Always enjoy your videos and tips. This one was particularly interesting (and yes, fun!)
Glad you enjoyed it!
Leila is a gamer. Man I was really good at VBA in college. Forgot all this now lol
That's was great Thanks
During this video my brain could handle learning about how UPC codes are structured. Towards the end though my brain exploded when presented with the VBA array layout.....OMG that is HIGH LEVEL ADVANCED stuff.
Where do we get the manufacturer code and product codes? Can this barcode be used for official business?
Thank you Pete and Leila you have my admiration and respect. Such ingenuity. Leila I know I am but a man but I am totally in love with you. You are a flawless diamond! Now I am going to sign up for one of your VBA courses (hoping there is a basic one) so I can maybe try this myself. Thank you both.
Our pleasure!
Thank you LG and also Pete for sharing this nice secrete of bar code.
Our pleasure :)
Wonderful, I Love the way that you explain everything. Your are the best!!!
Thank you for the kind feedback Daniel.
@@LeilaGharani 😍😍😍😍😍😍😍
" doesn't sound so healthy... but I already finished it." So cute.
If you only need a few of them, Microsoft Word can create barcodes and QR codes using field codes. That's another kind of learning project, I guess, but it works nicely once you get the hang of it.
I like it. But, I work in a warehouse and make barcodes all day in excel using a barcode font and placing an asterisk in front and rear of the data to scan. No VBA needed. We use code 128 barcodes btw. Always nice to learn a bit more VBA though.
very nice information
Thank you,,,, you are make Excel easy for me
Glad to hear that :)
Ameging, good work , god blessed you
Nicely done. Always enjoy seeing creative uses of the powerful capabilities of Excel. Your videos are always to the point and well produced.
Thank you for the kind words Andy.
That is good video.. helpful
Excellent work, you and Pete!
thank you so much Ms. Leila and Mr. Pete it was really useful and great video to watch I really appreciate.
Amazing madam. Very very helpful video. You are redefining the way of doing work and business. Thanks for sharing the same
One more lovely and useful video with clear explanation.
Thank you very much madam...
greetings from Maurituis...
Thank you for the kind feedback :)
Very good and clear explanation as usual. Thank you very much.
Wonderful video
Please also make a video How to Track/insert Inventory in Excel with Barcodes Scanner
Creating inventory barcodes in Excel - that would be cool! Or barcodes for entry to events - the mind boggles. Just need to know how to get own barcodes recognised by a scanner
Like the idea that uses VBA to only update based on changes within certain cells.
I'm wondering how I could use this on some existing data please? For example, I have two columns of information - Name and Part Number. How could I pipe these into this spreadsheet to end up with a third column that had the barcodes for column a & b that I can then print out on a barcode printer?
Great video Leila, I learned a lot. :)
3 Years ago I created an inventory application in Excel using a cordless barcode scanner to enter stock items AND control Excel (Yes, No, Retry, etc) ... combining it with the "Application.Speech.Speak" in vba the Excel app was able to provide audio feedback to the user. This was important because the stock items and the user's computer were not located in the same part of the office.
I printed out a sheet of barcodes from a generic online barcode generator) for various functions such as: item brand, item category, quantity, yes, no, retry, enter, etc. If they scanned the wrong code Excel would say "that is the incorrect barcode, please try again". Once they had scanned all the details for the stock item they scanned ENTER, and Excel would confirm the entry by saying "Item has been entered".
Who knew you could completely control Excel with a barcode scanner, huh?
Wow, that's some serious application.
It just took some out-of-the-box thinking, but it worked very well.
AWESOME INFOs AND VIDEO
It came on my recommendation, I went all ears!!
Wow. Looks exactly like something I would do. Recreating the wheel in Excel just because I can! I’ll probably be recreating this as well with a few updated functions (LET for example).
Excel data to barcode labels - you can first enter multiple barcode values in Excel, and then import them into our barcode generator software to make bulk barcode labels, this way can improve the work efficiency.
This is super stuff, Leila. I learned a lot from your youtube lessons - Thank you.
yes
When your only tool is a hammer, everything looks like a spreadsheet...
PERFECT presentation! Wow!!!!
Thanks a lot Leila. It's really great to follow your video tutorial. It is superb
Thank you for following Amilcar!
Tanks Leila and Pete!
Great & helpful , thanks Leila & Pete .
Really a cool gadget! Thank you Leila and Pete!
Our pleasure :)
Thanks Pete.
Nice video; extra tip, there are charachter sets available (free) to create the bars more easily (without VB)
SHEIKH ABDUL AZIZ
YOUR VIDEO IS VERY GOOD THANK YOU, MAM
Simple but elegant!
Thank you Pete and Leila
Most great one I do like ur way in explaining the formula. Best wishes
Very cool video👍
Now I can add the most used items I use on the job.
Hope it will be helpful at work.
@@LeilaGharani I'm pretty sure it will be a powerfull tool. Right now I copy/paste the EAN No. (barcode No.)from the manufactor website, into our NAVISION system, which can take ages. So this tool will deffently save time and improve the efficacy. 👍
I do this all the time without VBA Leila. You just need a font (I use 3 of 9 barcode font), and a concatenate formula. I'd be happy to send you a sheet. It couldn't be simpler.
Correct, I managed an entire test article inventory and tracked which parts were used/reused on what test articles using this method, a scanner, and a sticker printer. Much simpler than this method.
Can you explain what you mean by a font and concatenate?
@@wackolas there are free fonts available for some barcode types, so you'd type **1234** change the style|font to that barcode font and it will turn into a barcode, like the wingding font. They use typography ligatures to turn a series of characters into another character(barcode)
Hi Leila!Really Interesting Tutorial,Love The VBA Code!Thank You And Thank You Pete For Sharing With Us :):):)
Thank you Leila. I would like to learn more about UPC Barcodes. For example returning the description, model number etc in different cells of a worksheet after having scanned a UPC of a product. (Using VBA or not)
There are also free barcode generators that have a "url based api" online that you just visit a specific url to generate a barcode image, same thing for QR codes some are also open source so you can setup your own server.
Basically set an IMAGE, or hyperlink, formula to contain your types and codes and you get an image back
Google sheets example
_Barcode,API URL,Type,Value,Image Type,
IMAGEFORMULA,barcodegeneratorwexamplewebsite/barcode/,c39,1234567,PNG,
_
With the formula for google sheets being
=IMAGE(B2&C2&"/"&D2&"."&E2)
When the spreadsheet fetches the image it goes to that barcodes specific url and the image gets generated then served to the spreadsheet.
The caveat being if you have ALOT of codes that ALOT of images to fetch so can take a bit and some services have rate limits.
Waw.. I newer knew that Excel can do this... and it was explained so detailly... Thank you so much.
This woman is so amazing. It's hard to meet a tech girl, much less one who does so much to help people.
yeah and one that probably isnt a lesbian hahahahaha
@@casewhite5048 wouldn't that be a waste.
@@UmarAlFarooq yeah but usually when they are tech oriented or can build things for themselves they swing that way
@@casewhite5048 I don't know about the other fields but the tech ladies don't usually.
Hi and thank you for this fine video, but can you please show us how to export or save the code number to an Excel sheet.
OK, agreed that a Barcode font is the way to go, and that a non-VBA solution is available via some lookup creativity
However, COVID 19 and isolation, so...
My contribution is that it can be solved with a stacked column chart . The first series is set to no fill and just displays the category names, the second series is then stacked on top and forms the barcode. Both series have the column Gap Width set to zero. The result is a barcode as a chart that is a perfect match for the UPC Barcode and is dynamic without code.
On a roll, I also achieved just the barcode based on using a Sparkline.
If there's interest, I'm happy to release my completed solutions
Take care, Stay Safe
Thanks for sharing. Never would have thought that you can do this in excel. Amazing!x Subscribed.
Glad to have you here!
There is another way I've been using it for ages and it is much easier and much more simple and reliable.
Share that please
@@justinemusoke2321 would like to share it if she allows me. she can even explain it on a video.
excellent work for inventory
This video explained how to create barcode. Could you please make video on how to link product details to barcodes.. thank you
Great idea, this will come very handy. My only question is why VBA, this is easier done with formulas (everything is better with formulas)
I love formulas too :) actually it would be interesting to use the new Excel dynamic arrays here.
Wow! VBA Barcodes - Thanks, Leila!!!
Something experimental - actually all the credit goes to Pete :)
Thank you Leila this very useful I will visit Pete's channel and I will subscribe and follow his channel. Again thanks
It's actually useful if one needs to mock-up bar code symbols for an application without investing in any special software. While there are web sites that will do it for free, one-at-a-time, in a spreadsheet, you could do several. Interesting use of columns to generate the image.
Definitely. Pete's solution is great!
Excellent Work Dear ,, i'm Really impressed your work
Would love if this could be modifiefied to print registered mail and certifified mail labels which have a different format