2 different Methods to create QR Codes in Excel are explained in this video.


VBA Code for creating QR Codes.
Sub QRCodeGenerator()
Dim URL As String
Dim QRCode As Object
Dim Location As Range
Range("B3").Select

On Error Resume Next
ActiveSheet.Shapes.Delete

Do Until ActiveCell.Value() = ""
URL = "https://quickchart.io/qr?text=" & ActiveCell.Value
Set Location = ActiveCell.Offset(0, 1)
Set QRCode = Sheets("VBA").Pictures.Insert(URL)

With QRCode
.Name = "QRCodeVBA"
.Top = Location.Top
.Left = Location.Left
.Height = Location.Height
.Width = Location.Height
End With
ActiveCell.Offset(1, 0).Select
Loop
End Sub

Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/

If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand

Subscribe to @XLnCADMalayalam for Excel, Word, PowerPoint, Access, Python and Power BI Tutorials in Malayalam.
https://www.youtube.com/c/XLnCADMalayalam

Disclaimer: If you click on my affiliates links, I am going to receive a tiny commission. The products that I advertise are the ones I believe in.
My Running Kit for Hyderabad Marathon 2025
https://amzn.to/44IILeG
Think Like an Analyst: Books That Helped Me
https://amzn.to/3SNy6bi
Mind-Opening Reads You Can’t Miss
https://amzn.to/43tM2fu

#qrcodeinexcel #exceltip #qrcodegenerator