I have I user form that is shown when the user presses a button on a
spreadsheet.
The code in the spreasheet is:

Public Sub startKnapp_Click()
userForm1.Show
End Sub

Then the userform is shown. I want to do certain things when the userform is
opened etc. count number of textboxes. How do you write code so that the
program does certain things directly when the userform is opened i.e. the
user shall not be forced to press a button or move the cursor over certain
areas etc.? Please help me if you know how! Thanks!