QR Code Function to Sub
Hello Experts, i found this function code to create a QR Code from specific Cell. But it works as "Formula" with this sintaxis: =@URL_QRCode_SERIES("qr_code_1",A3,,"qrCode")
How can i convert it to a Sub routine that works with a button click and Input Box? I mean instead of Cell A3 Value, uses the Input Box Value when i click a button.
Note: It uses Google API (https://ch
Could any of you help me with it?
Thanks!
Please Login or Register to view this content.
DisplayText is used to return the result, which is display text in the cell containing the function so is not needed. Given that, I am not sure what this function does. A correctly designed function exists to return a value but this one has side effects that are the main purpose.
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Jeff,
thanks for explanation and support. But sub its not working, it cant be assigned to a shape / button to run.
Could you support me with additional information and how to link it to a button?
Thanks!
I see two problems.
First my error. A Sub cannot declare a return type. Change the first line to remove the return type:
Also, a Sub that is called with a button may not have arguments. Your original function has arguments. When you use the original function in a cell you have to provide a picture name, and optionally picture size and Updateable. If you do not provide those as arguments, what do you want them to be when you push the button?Please Login or Register to view this content.
Hello Again, i updated the code with your fix. But still cant assign it to a button. (The code was not generated by my, its one that i google it)
In regards to your second question, for me its to create a shape with the QR code (Size 150 px) based on the InputBox information. I dont know if you refer to that arguments.
I think, a picture shape needs to be created with the macro, then assign the information from the QR generated, isnt it? If yes, i dunno how to do it... could you help as well with that?
Here is the code fixed with your suggestion:
Please Login or Register to view this content.
The original function requires you to provide a PictureName to call it.Originally Posted by pacosalasv
The code replaces an existing picture with another one at the specified URL. If you don't tell the Sub the PictureName, what picture do you want to replace when you click the button?Please Login or Register to view this content.
I want to create a new one each time i click , i mean, when i click it generates QR Code it Generates a new image with an unique number.
Its that possible?
Thanks as well for your support in advance
I found an other code and was able to modify with your suggestions, and works with the specic requierement.
I appreciate your help and support!!
here is the new code, if anyone needs it:
Please Login or Register to view this content.
I'm glad you found something that works. I am still having a hard time visualizing how your files works without having a copy.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks