QR code generator modification

[amaresh achar]

Hi.. in search of a simple but reliable QR code generator... I came across an useful Excel macro tool from below link:

Can anyone please help me to get the QR code (black and white cell array) in spreadsheet cell instead of an image format..!?

Thank you very much in advance,
Amaresh

 

[abdelfattah]

yes John , the same error shows in place of cells where contain pictures.

 

[John_w]

It all works exactly as described for me.

I just downloaded the .xlsm workbook, put my code in a new module, typed 123456 in B7, changed the formula in B1 to =Qrcode(B7) (Excel puts @ after the =) and ran my macro. B7 now shows the QR code as a visible cell comment:

 

[abdelfattah]

sorry john this is my mistake !
I don't enable macro , that's why shows me error .
now it works perfectly .
many thanks for your time & code