natanz wrote:

Sub ShowForm(FormName As UserForm)
FormName.Show
End Sub

but that doesn't work. Can anyone help?



The funny thing is that your userform1 doesn't inherit from UserForm
type and UserForm itself doesn't have Show method :)

Sub ShowForm(FormName As Object) should work.