How to Create QR Code In Excel (QR Code Generator)

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

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

Read the tutorial - https://trumpexcel.com/create-qr-codes-excel/

------------------------------------------------------------------------------------------
'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://chart.googleapis.com/chart?chs=100x100&&cht=qr&chl=" & 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

------------------------------------------------------------------------------------

✅ 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

#Excel #ExcelTips #ExcelTutorial