PDA

View Full Version : Ink Signature to cell



peterwmartin
01-09-2018, 07:20 PM
Hi all,
I am trying to have a userform that could write on with a pen and have it save the contents to a cell, more or less a digital signature.
Not sure if it is possible or which control to use? Textbox or inkEdit control so far I have only found info on adding cell contents to inkedit control, not the other way around.
What I want to create is a sign in or attendance sheet that people can sign on a tablet. Could someone point me in the right direction please?
thank you

peterwmartin
01-09-2018, 10:46 PM
Ok, so I now understand it would be an InkPicture control, does anyone know how to save that to a cell??

SamT
01-10-2018, 08:36 AM
First, choose an InkPicture Event: https://msdn.microsoft.com/en-us/library/ms823115.aspx

Then see: https://stackoverflow.com/questions/27021541/how-do-i-save-an-inkpicture-as-an-image-using-vba-for-excel-2013

Also, in the VBA Editor,press F2 to open the Object Browser. In the Object Browser, enter InkPicture in the bottom dropdown window and click the Binocular icon next to it.

peterwmartin
01-10-2018, 08:59 AM
Thanks SamT,
I am off to work now, will give it a go later.