Out of Memory USERFORMS very large

I am writing a USERFORM for a Walk to Emmaus Master Spreadsheet. There is so much information for the 3 day schedule and persons assigned to each task, that I have run out of memory. I assume the warning is being caused by too many fields and Subroutines to process each form.

Because the entire form has too many fields/controls to fit on the screen all at the same time, I tried to use a multiple page control to organize the data/form controls. Since I have run out of memory, I am trying to find a way to reorganize the fields so I can swap from one form to another. I could not find definitive information about how to organize a very large userform so I am trying to break the form into multiple modules.

Can you give advice about how best to proceed?

Thanks Ahead of time for your help...

Take Care,
Richard

Thank you for the quick reply MarvinP, Yes, I agree an access database would be a good way to store the information. But I recently joined the Walk to Emmaus organization and this is an application written by someone else years ago. I am trying to make the interface more user friendly. Data is entered on something called the Master Sheet and then fields from that sheet are automatically populated into many different reports on other sheets. A person clicks a tab and prints the sheet to print the report.

I know there is a 2gb memory limit on 32 bit Excel. Looking at the Task manager shows less than 1gb being used by excel. How can I trouble shoot a memory problem? I searched the internet without any success.

We are using the system you are describing, entering the data into normal rows and columns. The issue is, these are not normal rows and columns. We scroll a massive sheet, 447 rows by "BF" columns, looking for cells that need information. The cells that need information have a yellow background. Cells are in many different sections. A section organizes the type of information. The person who designed this did a good job of labeling the sections where data must be entered but there are so many sections that the task of finding a specific section is daunting. A userform with tabs would simplify the process. Click on a tab to bring up the userform for a section, enter or modify the information, hit store, save the worksheet and your done.

Yes, I agree there must be a better way. I was hoping someone who encountered the same problem would tell me how they solved the problem. Do you know of any tool or debug procedure that will help me pinpoint the cause of the Out of Memory notice?

I saw that application you listed before deciding to write the userforms. The App, appears to plug into a row of data and requires column labels. This sheet does not fit those requirements, the labels are in the first cell of the row.