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.
----------------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
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

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

- Function & Simple Chart in Ms Excel

- Auto/dynamic border in Ms Excel using conditional formatting

- Allow and Protect edit blog of cells

[jorgeluissarmiento]

I struggled with a lot of videos and this was the easiest way to solve my problem. Thank you so much!!

[ismailparakkal]

QR Code with VBA Code is Working well. Thank you very much dear

[alexandremuller]

Thank you so much!!! Easy to understand. Very efficient!

[GE-EduCARE]

Your video is a nice one. I do have plenty in my channel. Yet, its something i have ever liked to watch the method of teaching.

[nounejm]

Thank you so much !. I want to ask if there is a option to put a "tab" and "enter" keys into the code. Thank you

[nursultanyerlanuly]

Thank you so much! Hello from Kazakhstan! I'm your new subscriber 👍💯

[مركزالتدريبوالتطويربجامعةعينشم]

Thank for your video, I can knew how to created an QR code in Excel, it's very useful for everyone. But may problem iS when i try to scan QR IMAGE NOT WORKING

[jovernpamintuan]

Very informative Sir, thank you for sharing this knowledge.

[thetone]

Thanks a lot mate, exacly what I needed. Subbed, cheers

[rahuldestty]

Thanks a lot dear, its really useful, is it possible to update the code and save all qr codes as jpg with name of files in another column.
Thanks again

[nelsonzamudio]

Thank you very much for your contribution, it has helped me a lot in a job that I am implementing, I have a problem and it is that in the rest of the pages of the same book where I make a change, the QR codes are placed, that is, as if the function were activated in all the sheets and I have to delete those QR images where they appear, again thank you very much for your help.

[hokheng]

លោកគ្រូ ប្រសិនបើខ្ញុំ ចង់បង្កើត QR តើយើងត្រូវធ្វើដូចម្ដេច?

[athinkt]

Qr code is generating successfully. But when ever I go to next sheet Qr code is also generating where ever I click in another sheet. Is there a way to generate QR code in a cell and lock aspect ratio

[FaisalSarosh]

I'm getting the same QR code for any text I have in the cell :( It generates the QR code but when the QR code is scan it gives the same result i.e. "QR Code". No matter what text I have input in the cell the QR code result is the same.

[bijimole]

Hai brother, I want to know about, If i need more information about one product, then how i can use this code?

[Zahwa_miku]

googleapis was deprecated, any others solution dor make qrcode

[sujayshirhatti]

Nice work bro. I have an issue but. I am trying to generate a complicated QR code which has @ or & symbols. The qr generated by your function is only creating the qr upto the first '&' and not ahead of that. How to solve this, please it will be really helpful.

[EASYLEARN]

លោកគ្រូ ទិន្នន័យដែលមានអក្សរខ្មែរ ពេលបម្លែងទៅជាQR CODE ពេលចុចscan វាមិនចេញអក្សរខ្មែរទេ

[alexandremuller]

Any idea about how to remove the margin (white string) around the QR code?

[ibrahmburghol]

Did you ever figure out how to not have the previous code appear when using the drop-down?