TrumpExcel's video: How to Create QR Code In Excel QR Code Generator

[Update] I showed how to generate a QR code using https://chart.googleapis.com/ API, but it seems to not work anymore. You can use https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=[Your Data] instead. I have updated the article here (also includes the download file with a working QR code formula and VBA code) - https://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 https://trumpexcel.com Function GETQRCODES(QrCodeValues As String) Dim URL As String Dim CellValues As Range Set CellValues = Application.Caller URL = "https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=" & 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 - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course ✅ Free VBA course - https://bit.ly/excel-vba-course ✅ Free Power Query Course - https://bit.ly/power-query-course ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1