How to Create Code for the Onscreen Numeric Keypad for Excel
- 1). Open the Excel spreadsheet you are working on.
- 2). Press "Alt"+"F11" to open VBA.
- 3). Double-click your spreadsheet.
- 4). Copy and paste the following function to the Visual Basic editor:
Private Sub CommandButton1_Click()
DIM RetVal as variant
RetVal = Shell("C:\WINDOWS\system32\osk.exe", 1)
End Sub - 5). Click "Play." This opens the onscreen keyboard so that it functions in Excel. This will open each time your open the spreadsheet.
Source...