Capture Signature in Excel Form

[grabrail]

Hi, I am looking to create a form in excel (moving away from paper forms) where we need a candidate to sign their name.

The solution I am looking at, is to buy USB scribble pads for each of our instructors, and this is used to do their signature, this would be done on a pop up form.

What I am struggling to get my head around is once they have signed the box, how does the signature "Object/Image" populate the value of the box? So, once they submit, it can be populated in the correct place on the main form?

Im trying to avoind the digital sinature route if possible, but this is not fully discounted yet.

 

[grabrail]

Ive managed to get what I need.

If anyone else is interested in achieving a similar scenario.

I created a form, and on the tool box in VBA editor, choose additional controls. Scroll down the list and select Microsoft InkPicture Control

On your form you can add an inkpicture box, which will allow for drawing in.

I added the following code

Private Sub CommandButton1_Click()

Worksheets(ActiveSheet.Name).Range("i11").Select

Me.InkPicture1.Ink.ClipboardCopy
ActiveSheet.Paste
Set newImg = Selection
With newImg

.Name = "Signature"
End With

UserForm1.Hide

End Sub

Private Sub InkPicture1_Stroke(ByVal Cursor As MSINKAUTLib.IInkCursor, ByVal Stroke As MSINKAUTLib.IInkStrokeDisp, Cancel As Boolean)

End Sub

Private Sub UserForm_Activate()
    
    Me.InkPicture1.Ink.DeleteStrokes

End Sub

This is all controlled from an activex button on the excel worksheet.

when you click the submit button after drawing your signature, it will copy that ink to the selected cell in the code above (i11)