2 Methods to create QR Codes in Excel

Ajay Anand
Ajay Anand
4,550
0
Published 2023-07-10
2 different Methods to create QR Codes in Excel are explained in this video.

🍐Join my online course on Excel Tables
www.udemy.com/course/tables-in-excel/?referralCode


🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD

🍇Check these Books on Excel
xlncad.com/excel-resources/

🍉Read my articles on Excel
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 = "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
All Comments (2)