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
Nesta página do site você pode assistir ao vídeo on-line Create QR Code in Excel | 2 Methods duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Ajay Anand 10 Julho 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 15,770 vezes e gostou 122 espectadores. Boa visualização!
