Un-hiding userform

[colosgps1975]

My entire workbook coding is rather complicated, but here is my problem:

A button on UserForm1 in Workbook1 opens a new Workbook (Workbook2) based on textbox values in UserForm1. Prior to opening Workbook2, I hide UserForm1. Then I can fill in WorkBook2 as needed. I have a button in Workbook2 that saves the workbook and exits. Now, I return to WorkBook1. I need to 'unhide' UserForm1. There are values in UserForm1 that I need, so I can't unload it. But upon returning to WorkBook1, if I do a UserForm1.show command, I then have 2 UserForm1's loaded.
Any ideas? Thanks to all. This board is awesome.

 

[Andrew Poulsom]

I can't reproduce your problem.

I ran this code:

Sub ShowForm()
    UserForm1.Show
End Sub

to show a UserForm with a TextBox, two CommandButtons and the following code:

Private Sub CommandButton1_Click()
    UserForm1.Hide
End Sub

Private Sub CommandButton2_Click()
    MsgBox UserForms.Count
End Sub

No matter how many times I click CommandButton1 and rerun the ShowForm procedure, clicking CommandButton2 only returns 1 (UserForm loaded).

 

[colosgps1975]

The problem is that I lose information in the textboxes when the form is reloaded

 

[Andrew Poulsom]

If I enter something in the TextBox and click CommandButton1 to hide it, it's still there when I show it again.

Do you have something in the Userform's Activate event procedure that is resetting the controls?

 

[colosgps1975]

Thanks for the reply. I did have activation events. But I worked around it by placing a value in a cell. Then when the userform activates, if that cell contains that value, it bypasses the code and resets the number. Works great now. Thanks again.

 

[Andrew Poulsom]

If you use the Initialize event instead of the Activate event, it will only fire when you first show the UserForm (ie it is Loaded).