I am using the QR Code and not code 39. Qr code works much better and quicker.
Hear is a screen capture of my calendar item:
https://www.msofficeforums.com/attac...1&d=1619701970
Here is what the webpage looks like that I have to type in the data
https://www.msofficeforums.com/attac...1&d=1619701970
If I select the Inspector field(1) and type in the inspector, when i hit the tab key, it will take me to 2 then 3 ,4,5 etc.
So, my form line 2 actually enters into webpage 7
My form line 3 enters into webpage 11
My form line 5 enters into webpage 6
My form line 6 enters into webpage 8
and as for the vin, they want just the last four digits of it to be entered in to webpage 12
So now I want to add QRs for the other items on the Webpage form, being
Webpage1
Webpage2
webpage3
webpage4
Webpage5
Webpage9
Webpage10 (Checkbox)
When I run the qr macro, it looks like this
https://www.msofficeforums.com/attac...1&d=1619701970
So I would have to scroll down the form to get to the other fields.
I am hoping to get it to put 4 qrs per line so it ends up looking like this
https://www.msofficeforums.com/attac...1&d=1619701970
What I was wondering about is creating 12 variables. Each variable would have the written text followed by the QRcode.
Then I could simply put each variable plus chr(32) or chr(34) where needed.
I could also just add my items for webpage1, 2,3,4,5,9, and 10 into the code before the for next loop because they really wont change.
Hope this clears it all up
Thanks again for all your help