Create QR Code in Excel | 2 Methods
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 - • Top 25 Microsoft Word Tips and Tricks
🍓 7 Most Important Tools in Excel - • Most important Tools in Excel
🍏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.
/ 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
On this page of the site you can watch the video online Create QR Code in Excel | 2 Methods with a duration of hours minute second in good quality, which was uploaded by the user Ajay Anand 10 July 2023, share the link with friends and acquaintances, this video has already been watched 15,770 times on youtube and it was liked by 122 viewers. Enjoy your viewing!
