hureechunder
New Member
- Joined
- Sep 13, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
- Web
This problem has been driving me insane...so thanks in advance for your help!
I have an excel workbook with a single sheet visible (the rest are hidden), and two user forms as under.
When I hit F5, I can run cmdButton1 with no problems. However, running cmdExit gives me an 'Out of Memory' error. I get exactly two 'Out of Memory' prompts one after the other, corresponding to the number of subroutines.
As a test case, I removed the 'Userform2.Show' line under cmdButton1_Click, and that also gave me an 'Out of Memory' error when running.
Is there a rule that prevents all user forms to be unloaded at the same time?
Private Sub cmdButton1_Click()
Me.Hide
UserForm2.Show
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdButton1_Click()
Me.Hide
UserForm2.Show
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
I have an excel workbook with a single sheet visible (the rest are hidden), and two user forms as under.
When I hit F5, I can run cmdButton1 with no problems. However, running cmdExit gives me an 'Out of Memory' error. I get exactly two 'Out of Memory' prompts one after the other, corresponding to the number of subroutines.
As a test case, I removed the 'Userform2.Show' line under cmdButton1_Click, and that also gave me an 'Out of Memory' error when running.
Is there a rule that prevents all user forms to be unloaded at the same time?
Private Sub cmdButton1_Click()
Me.Hide
UserForm2.Show
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdButton1_Click()
Me.Hide
UserForm2.Show
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub