How to Create QR Code In Excel (QR Code Generator)
79,762
Published 2023-06-13
I have updated the article here (also includes the download file with a working QR code formula and VBA code) - trumpexcel.com/create-qr-codes-excel/
-----------------------------------------------------------------------------------------------------------------------------
In this video, I will show you four methods you can use to generate QR codes in Excel.
If you are using Excel with Microsoft 365 or Excel on the Web, you can use the IMAGE function to instantly generate QR codes within a cell.
And in case you are using older versions of Excel, you can use an Excel add-in, an external website, or a QR Code Generator VBA code.
00:00 Intro
00:24 Generate QR Code Using IMAGE Function
03:46 QR Code Generator Add-in
06:30 Using Website to Create QR Codes
09:00 VBA to Gneerate QR Codes in Bulk
------------------------------------------------------------------------------------------
'Code by Sumit Bansal from trumpexcel.com/
Function GETQRCODES(QrCodeValues As String)
Dim URL As String
Dim CellValues As Range
Set CellValues = Application.Caller
URL = "api.qrserver.com/v1/create-qr-code/?size=150x150&d…" & QrCodeValues
On Error Resume Next
ActiveSheet.Pictures("Generated_QR_CODES_" & CellValues.Address(False, False)).Delete
On Error GoTo 0
ActiveSheet.Pictures.Insert(URL).Select
With Selection.ShapeRange(1)
.Name = "Generated_QR_CODES_" & CellValues.Address(False, False)
.Left = CellValues.Left + 2
.Top = CellValues.Top + 2
End With
GETQRCODES = ""
End Function
------------------------------------------------------------------------------------
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial
All Comments (21)
-
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
-
Awesome work. Easy to follow, easy to understand. Keep up the good work.
-
I have learnt lots from your tutorials. Thank you very much! Please keep us updated you are AWESOME!!
-
Very informative and definitely a great learning experience
-
You saved my day! Thanks a lot for such infomrative content
-
exactly what I was looking for! Thank you
-
Excellent Video.I am Truly Learning Alot From You.
-
Very useful tutorial and we'll explained.
-
Great video! Thank you for sharing.
-
Excellent tutorial. Thank you Sumit!!! That's works super! Thank you.
-
very goood, specially in online Questionnaire forms
-
Thank you this is very useful
-
Excellent Video - I DO like them - thank you
-
Thank you!!!!!
-
You saved my Life
-
I am fan of your videos
-
After Google you are the best teacher to me and lot of guys too, but I wanted download material from your website, but I can't, please assist to me
-
Thanks for the share.
-
Hello, how to make the =image function available? My excel is on the latest version. Thank you!
-
Is there VBA option for pdf417 code also?