How to generate QR Code in Excel using VBA | Create QR Code In Excel

Описание к видео How to generate QR Code in Excel using VBA | Create QR Code In Excel

How to generate QR Code in Excel using VBA with Googleapis QR Code
*** Note: Connect the internet when you test this example, If you don't have internet it cannot work.
Full QR code VBA source code: https://bit.ly/41M79YY
---------------About Us--------------
#QRCode #Excel #VBA #PutheaTraining
សូមជម្រាបសួរបងប្អូនទាំងអស់គ្នា! ទីនេះជាទីកន្លែងសម្រាប់ធ្វើការបង្ហាញ ណែនាំ បង្រៀន អំពីចំណេះដឹង បច្ចេកវិទ្យា និងស្វែងយល់អំពីកម្មវិធីសម្រាប់ការប្រើប្រាស់ធ្វើការងារប្រចាំថ្ងៃរបស់លោកអ្នក។ សូមជួយគាំទ្រ Channel នេះផង។

Hello everyone! This is a place to introduce, teach, and learn about the program for your daily work. Please support this Channel.
-------------------Code-----------------------
Function GenerateQR(qrcode_value As String)

Dim URL As String
Dim My_Cell As Range

Set My_Cell = Application.Caller
URL = "https://chart.googleapis.com/chart?ch..." & qrcode_value
On Error Resume Next
ActiveSheet.Pictures("My_QR_CODE_" & My_Cell.Address(False, False)).Delete
On Error GoTo 0
ActiveSheet.Pictures.Insert(URL).Select
With Selection.ShapeRange(1)
.Name = "My_QR_CODE_" & My_Cell.Address(False, False)
.Left = My_Cell.Left + 5
.Top = My_Cell.Top + 5
End With
GenerateQR = ""

End Function

---------------------------------------------
Video timestamp :
00:00 Result intro
00:09 Intro
00:20 Create table in Excel
03:47 Coding vba code
06:18 Save Excel and code
07:10 Test for QR code generator

- Easy How To Create QR In Google Sheets | Generate QR By Your Self
   • Easy How To Create QR In Google Sheet...  

- Difference between IF and IFs In Excel | How to use IFs
   • Difference between IF and IFs In Exce...  

- Function & Simple Chart in Ms Excel
   • Function & Simple Chart in Ms Excel -...  

- Auto/dynamic border in Ms Excel using conditional formatting
   • Auto/dynamic border in Ms Excel using...  

- Allow and Protect edit blog of cells
   • Allow and Protect edit blog of cells ...  

Комментарии

Информация по комментариям в разработке