[Update] I showed how to generate a QR code using chart.googleapis.com/ API, but it seems to not work anymore. You can use api.qrserver.com/v1/create-qr...[Your Data] instead.
I have updated the article here (also includes the download file with a working QR code formula and VBA code) - trumpexcel.com/create-qr-code...
-----------------------------------------------------------------------------------------------------------------------------
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..." & 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-c...
✅ 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: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial