[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

VBA - Simple I hope ! "Out Of memory"

THis could be fairly simple - I hope!  It could be basic syntax.

I have a simple form from which sub cboUpdateReport_Click() is called.

This code works well as I F8 through it.
However, after "End Sub" it gives "Out of Memory" error.

This is a very small workbook with no demands on memory.
Is there something wrong with the way my sub ends?
Why is it giving this error.


Private Sub cboUpdateReport_Click()
Stop


Worksheets("Controls").Cells(2, 7).Value = frmReportParameters.cboCompanyName.Text
Worksheets("Controls").Cells(3, 7).Value = frmReportParameters.cboYear.Text
Worksheets("Controls").Cells(4, 7).Value = frmReportParameters.cboPeriod.Text
Unload Me

End Sub


Private Sub cmdCancel_Click()
Stop
Unload Me
End Sub

Open in new window

0
Patrick O'Dea
Asked:
Patrick O'Dea
4 Solutions
 
Rgonzo1971Commented:
Hi,

Is your code module also small?

Regards
0
 
MacroShadowCommented:
That code should not give you an Out of memory error. Does your workbook have more code?
0
 
Patrick O'DeaAuthor Commented:
There is no other code in the workbook.

I notice that the workbook is almost 3 meg in size.

Would this be a problem?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
MacroShadowCommented:
The only other thing I can think of is formulas causing the error. Does it only err out when you run the code?
0
 
byundtCommented:
There have been a number of questions on "Out of memory" problems recently. Microsoft is investigating the issue.

In the mean time, try rebooting your computer.
0
 
Martin LissRetired ProgrammerCommented:
Is there any code in the UserForm_QueryClose or UserForm_Terminate events that refers to the UserForm?
0
 
Patrick O'DeaAuthor Commented:
Folks,

The matter seems to have resolved itself .... not sure why tho??
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now