I have a spreadsheet with a fairly complex userform that acts as a UI. I believe the issue is caused by the ammount of controls i have on my userform as it was working fine upto a point. I have already upgraded from 32 bit excel to 64 which solved the issue at an earlier stage when i had less controls but my userform is nearly complete and i am having issues again. Its likely that i am handling memory very poorly in my VBA functions so i am wondering firstly is there a way for me to just allocate more memory to excel so that i do not have to modify anything. And secondly are there any tips for how i should manage data within my subroutines. I could change my userform to contain less controls but im not sure how i can change it and still get the same affect i have now. There is too much involved in the sheet for me to post code so here is a link I know the code is messy and i could create more subroutines that can be called many times instead of writing the full function again but i dont believe this is the issue.
I would very greatly appreciate any advice.
(note not all pages are completely functional due to the out of memory error but all the controls i need to get it working at present, I will include an earlier functioning sheet to show how it should work. The spreadsheet its self is fully functional with the same functionality as the userform)
I would very greatly appreciate any advice.
Google Drive: Sign-in
Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).
drive.google.com
(note not all pages are completely functional due to the out of memory error but all the controls i need to get it working at present, I will include an earlier functioning sheet to show how it should work. The spreadsheet its self is fully functional with the same functionality as the userform)
