2 Methods to create QR Codes in Excel

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

🍐Join my online course on Excel Tables
https://www.udemy.com/course/tables-i...

🍓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/

🍏Playlist for Shorts on Excel
   • Short videos on Excel Tips & Tricks  

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

#qrcodeinexcel #exceltip #qrcodegenerator