Digital Signature

[Alvis]

Hello Everyone,

Happy New Year ! Hope you all had a nice time with your Family, Friends, Relatives..

Starting a New Year with a new challenges on Excel !

Basically I'm trying to build a 'Goods In' spreadsheet.

Made the macro which gives unique ID for each delivery we are getting in the warehouse, etc..

I'm thinking to use the Tablet with excel on it for people to sign for they parcel (once collected from goods in) and the issue I have now is to add the signature for each collection..

So far example I have:

Delivery ID
Date Received
Courier
Etc...

What I want to do is when someone comes to goods in and asks for Delivery ID 7 (for example) the guys would take the tablet, press on the macro button which will ask which delivery ID is due to be collected. They type delivery ID 7 and then signature box pop up. Once the person signs for the goods the signature is being linked to that delivery ID.

Hope I explained it clearly And also I hope this is possible to do ! Never tried this and struggling to find the solution at the moment.

So many thanks for your suggests

Thank you
Alvis

 

[Logit]

.
I found this resource which appears to discribe in some detail what you are seeking. I have not attempted any of the directions located on this
resource. Hopefully this will get you started ...

https://stackoverflow.com/questions/37164849/ink-tools-vba-excel-digital-signature-drawing

 

[Alvis]

Hi Logit,

Many thanks for this! I went through it and it kind of does the job just had some error messages but I think it should do the job, will find the ways around it.

Kind Regards
Alvis

 

[Logit]

.
You are welcome.