Make Excel Become Your Signature Pad

Do you often sign off all kinds of documents ranging from company contract to your kid's results slip? With Excel, you can actually make your own stunning signature pad. In this section, you will learn how it is done in Excel.

"Every great dream begins with a dreamer. Always remember, you have within you the strength, the patience, and the passion to reach for the stars to change the world." - Harriet Tubman

As usual, open the VBA editor by right clicking the sheet name area at the bottom. Select View Code or simply use the hot keys Alt+F11. Then in the Project Explorer area, right click ThisWorkbook -> Insert -> UserForm.

Most importantly, you need to add the Microsoft InkPicture Control into your Toolbox manually. The reason why is that control is not added by default. Once you check the box in front of Microsoft InkPicture Control and click OK, an additional control "InkPicture" will appear at the end of your Toolbox.

Now let's add an InkPicture control onto the user form. You can add two command button controls and name them as "Confirm" and "Clear". "Confirm" button is gonna be used to save the ink strokes to the Excel spreadsheet while the "Clear" button can be used to empty the strokes that you don't like.

You can copy the below codes for "Confirm" button.

Private Sub CommandButton1_Click()

InkPicture1.Ink.ClipboardCopy

With ThisWorkbook.ActiveSheet

.Range("A1").Select

.Paste

End With

Unload UserForm1

End Sub

Then copy the below codes for "Clear" button.

Private Sub CommandButton2_Click()

With InkPicture1

.Enabled = False

.Ink.DeleteStrokes

.Enabled = True

End With

End Sub

Finally add a button on Sheet1 which is "Show Signature Pad" and use the below codes to pop up the pad window.

Private Sub CommandButton1_Click()

UserForm1.Show

End Sub

Well, everything is ready. You can start to sign your name on your own signature pad.