Create Qr code Function in MS Excel Using VBA.

Показать описание

In This Video you will learn how to Create Qr code in MS Excel Using VBA. With very Easy and simple Method.
-----------------------------------------------------------------------
qr code excel 2007.
qr code excel generator.
qr code excel 2010.
qr code in excel.
generate qr code in excel.
add qr code in excel.
qr code excel vba.
qr code excel 2019.
create qr code in excel.
create qr code in excel 2007.
create qr code in excel 2010.
qr code excel offline.
create Qr code using VBA.
------------------------------------------------------------------------
VBA for Qr code function
------------------------------------------------------------------------
Function QrCOde(codetext As String)
'If There Not Internet Connection The Coding Does not work
Dim URL As String, MyCell As Range

Set MyCell = Application.Caller
On Error Resume Next
ActiveSheet.Pictures("My_QR_" & MyCell.Address(False, False)).Delete
On Error GoTo 0
ActiveSheet.Pictures.Insert(URL).Select
With Selection.ShapeRange(1)
.PictureFormat.CropLeft = 10
.PictureFormat.CropRight = 10
.PictureFormat.CropTop = 10
.PictureFormat.CropBottom = 10
.Name = "My_QR_" & MyCell.Address(False, False)
.Left = MyCell.Left + 25
.Top = MyCell.Top + 5
End With
Insert_QR = ""
End Function
------------------------------------------------------------------------
------------------------------------------------------------------------
channel Link 🔗
------------------------------------------------------------------------

#Excel
#MsExcel
#shehryarteachcomputer
#Programing
#VBA
#qrcode
#barcode
#qrcodeinexcel
#barcodeinexcel