QR Code Encoder VBA library

User avatar
HansV
Administrator
Posts: 78391
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: QR Code Encoder VBA library

Post by HansV »

Let's hope someone else knows how to do that with VBA.
Best wishes,
Hans

User avatar
SpeakEasy
4StarLounger
Posts: 544
Joined: 27 Jun 2021, 10:46

Re: QR Code Encoder VBA library

Post by SpeakEasy »

Try

Code: Select all

    With ActiveSheet.Shapes("imgQRCode")
        With .PictureFormat
            .TransparencyColor = RGB(0, 0, 0) ' Original QR Code colour
        End With
        .Fill.BackColor.RGB = RGB(0, 0, 255) ' Desired QR colour
    End With

YasserKhalil
PlatinumLounger
Posts: 4911
Joined: 31 Aug 2016, 09:02

Re: QR Code Encoder VBA library

Post by YasserKhalil »

Amazing. That worked very well.
Thank you very much.