In the Userform_Activate code, add this as the first line...
Me.Repaint

note: when you open a workbook it becomes the active workbook.
--
Jim Cone
Portland, Oregon USA



"ChrisP"
wrote in message
I have a worksheet which has a button. When the button is pushed it shows a
userform, the userform code calls other sub to run. My problem is that the
userform is not showing up correctly. The title is showing but the inside of
the form is completely white (which is not what I made).

Here is my code:

Button code:
Private Sub CommandButton1_Click()
UserForm1.Show
End Sub

UserForm code:
Private Sub UserForm_Activate()
Call testing
End Sub

Testing code (which is in a Module):
Sub testing()
Workbooks.Open Filename:="\xxx\Template.xls", UpdateLinks:=0
ActiveWorkbook.Close
Unload UserForm1
End Sub

How do I make the middle of the form visible? What am I doing wrong?
Thanks,
Chris P