I could be wrong, and frequently am, but from what I can see in the Show
Method decription, only DialogBoxes offer the argument () option. It does
not apply to the UserForm.Show method.

"kirkm" wrote:


The Brackets in the Show Command e.g.

frmMyForm.Show ()

... what are they used for?

I thought it was for passing a variable, but if I put
one in the brackets, how can I read it ?

I've tried

Private Sub UserForm_Activate(x)
End Sub

Private Sub UserForm_Initialize(x)
End Sub

Bring up an error 'Procedure declaration does not match description of
event or procedure having the same name'

I can't find a 'Form Load' or any place in properties to use.

What am I doing wrong?


Thanks - Kirk