Userform in Excel is blank

C

ChrisP

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
 
A

AndyM

When UserForm1 is launched, Sub testing is called right away. Within this
sub, the form is being closed "Unload UserForm1".

If you are able to open the form and it is blank, check to see if any of the
form objects have a value of False in the Visible property.

If you take out the "Unload UserForm1" statement you should be able to see
the form though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top