Hello everybody,
This is the macro I’ve been wanting to make for a while.
First of all, I would like to remind you! I am not a programmer, the macro I made is to meet my needs. And it works well enough to meet my needs for now.
It would be great if someone who understands the software could fill in the shortcomings of the macro.
It adds the text written in the textbox to the page as a QR code.
The reason I went with the macro is that it is a single file, does not require installation and I want to write only with VBA. The address where I downloaded the QR code generating module is written on the module page. Does not require internet.
As I said at the beginning, this macro is just to meet my basic needs. “Be sure to test it!” I’m sharing it in case anyone wants to improve it.
2023-10-02_14-04-41.jpg
Thank you for sharing 
Actually i thank you. This is such a small thing compared to what you have done for us. Mr. Gupta I learned a lot from you.
Awesome work Omur! I might give it a try and see if we could replace our bar codes with these.
I’m looking forward to your return, my mate.
Would like to test it, but seems missing the QRGen file.
image.png
image.png
You don’t need to add any references.
That reference is from a different attempt.
I added a module to create a qr code, but if you need to add it too, I’m adding it here.
image.png
VbQRCodegen-master.zip (17.6 KB)
https://github.com/wqweto/VbQRCodegen
(Thanks, sorry but it throws another error. Let’s see if Alex can test it.)
After clearing the select box of the missing reference, runs great. Good job.
image.png
Sorry, I didn’t quite understand, is it working smoothly now?
Yes, runs smoothly now.
image.png
Thank you very much for the feedback. It’s nice to be useful to someone, the qr code link is nice.
Thank you for creating this tool.
Might flood the SWYM’p with this code. 
A very well done job. Thanks
I get this error when I run it:
image.png
image.png
Had the same error. You have to de-select the missing reference, see my post above.
image.png
Thanks Frank, didn’t think it was the same error.
After clearing it, it works like a charm. Here’s the macro with the missing reference removed for those who don’t know how to remove it.
Yes, I added that reference without removing it. Good thing you removed the reference and added it, I forgot to add it again.
Thanks Alex
Many thanks Ömür. This is a really useful code.
I use it for displaying dropbox-links for pdf and edrawings on the SolidWorks drawings.
When it inserts the picture it varies a great deal in size. Is there an easy way to adjust this size to a fixed value within the code?
What would be truly awesome is if the code was able to get the dropbox path of the pdf with the same name as the drawing and then paste that into the window. Is that at all possible within a macro in SW or is that wanting too much?
I get the following error whenever I run the modified version shared by Alex:
This happens after I type something in the box and select “generate QR Code”
I am using SW 2022 SP4 on Windows 10
In the VBA editor, go to ‘Tools-> References’. There is probably a broken reference that either needs to be unchecked, or more likely pointed to the correct dll.
This link has a more thorough explanation.
https://kb.blackbaud.com/knowledgebase/Article/75344