Have you put the code in the userform code module (not a normal code
module)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Doug" wrote in message
...
When showing a UserForm, I tried to use this code:

Private Sub UserForm1_Activate()
MsgBox "hello"
Place code here that or call another sub rotine from here
End Sub

The UserForm opens up, but the Msgbox does not appear. What am I doing
wrong? Thank you.

Doug