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()
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
Private Sub cmdCancel_Click()