Hi
I would like to use Shapes in excel, instead using userform as the code below.
In this userform, it has command buttons for the numbers and the a text box to show the numbers.
How can I do it, using square shapes for numbers and another rectangle shape, to show the written numbers.
I would like to create a number keyboard using "shapes". I thank you in advance,for the help.
Private Sub cmd1_Click()

With txt1.Value
txt1.Value = txt1.Value & 1
End With

End Sub

Private Sub cmd2_Click()

With txt1.Value
txt1.Value = txt1.Value & 2
End With

End Sub

'and so on........

Private Sub cmdEnter_Click()

Dim iRow As Long
    iRow = Sheet3.Cells(Rows.Count, 1).End(xlUp).Row + 1
     With Sheet3
       .Range("a" & iRow) = Me.txt1.Value
     End With
  txt1.Value = ""
Unload Me
UserForm2.Show

End Sub