A user form can be made in the Visual Basic for Application framework (where macro can be edited).
Userforms are containers to hold ActiveX controls (as Spreadsheets are).
Private Sub CommandButton1_Click() UserForm1.Show End Sub