How to Create QR Codes in Excel - Tutorial, no Add-Ins

How can you make a QR code for just a number for scanning on an inventory system scanner? The QR code appears but doesn’t generate that search for number command.

can you help please, my data is in more row who contains four column. what become the codes?

ขอบคุณมากค่ะ มีประโยชขน์มากเลยค่ะ ตามหาvideo ที่ทำง่ายๆแบบนี้เลยค่ะ

Hi! Thank you for this tutorial! How can we get this to print to Avery labels with a name next to it? Thanks!

what if we want to make the QR code as downloadble pdf and it is locked? SHould we use Github too for repository?

👍

Great Video. Is it possible to do all-in-one QR code for all Social media for instances?

Is there a way to make datamatrix code just like this?

Thank you so much! You have saved me hours of work 😢 thank you!

My apologies it’s working just fine now. Great presentation

I checked again today and the website is working now

I tried the example only got a white screen. Perhaps website it down

Very helpful, thank you

Please show me how can I save all qr code from PNG file in worksheet to computer?

This is a good video. But, the scale is going to be 1 and 1 for the horizontal and vertical widths if you've already set the size of the cell to match the 150x150 size that you're generating. Any time the cell size already matches the image size, there' no point in scaling it. I'm not even sure that those lines really even need to be there, but it's nice if you eventually decide to change it. (For example to have a larger and a smaller on in the same sheet)

I cant do the same, show the error 1004 - it is not possible to get the Insert property of the picture class... Only do 1 qr code, but 2 or plus i cant do the looping... Do you can help me?
Thanks

You are great!

Great video!! Short code and effective

Just Great ! Extreme clarity on the process with simple explanation supported with clear voice.

Loved this, exactly what I'm after
Is there a way to just have this show "Data Information"
IE : Production information of a Job Number
Say;
Date ######
Operator #####
Shift ##
"EncodeURL" is for Web Address, can other functions be used ?

Regards, Trevor

Does this process make a dynamic QR code? If I were to change the destination URL in the future, would the QR code image stay the same? Wanting to avoid having to re-print QR codes. Thank you.

This is great. This was short and to the point. I have to ask though, if the spreadsheet has merged cells then the does not work, how would we need to modify the VBA to ensure everything works with Merged cells. For example your QR code would take up two cells, the URL one cell and I would have a blank cell in between QR codes. Would love to see how to program for that scenario.

But I did love the video and it works beautifully.

very nice

can you also please show how to print this QR code on Labels by using printer such as Zebra? you are awesome btw.

this is great

This is awesome, I need to do this in Google sheets.