Excel VBA - UserForm

Card Puncher Data Processing

About

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





Discover More
Excel Developer Tab
Excel - Forms (In Worksheet)

You can add ActieX control to create a form in the worksheet. userFormuserForm To use the forms controls in Excel, you must enable the Developer tab. See How...



Share this page:
Follow us:
Task Runner