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).
How to call it ?
- when clicking on a button: Create a UserForm named UserForm1, add a button to the worksheet and attach the following code that shows the UserForm.
Private Sub CommandButton1_Click() UserForm1.Show End Sub
- When the workbook open. Add the UserForm1.Show code on the Workbook.Open event