PDA

View Full Version : Out of Stack Space Runtime Error 28 in MAC Excel 2011 VBA



aqw07398
11-15-2015, 08:21 PM
Hi All,

I created a program for easy data entry and searching of records in MAC Excel 2011 VBA. When testing on a MAC, after playing around with adding records, then going onto the search module and back, the error of out of stack seems to creep in. I tried debugging and found that the userform_activate function at some point did not trigger. This meant that certain procedures are not closed properly and are still processing, stacking up in the background but I cannot pin-point what is causing this problem.

I ran the program in windows and it worked fine with no errors.

I understand 99% of such errors is due to recursive-ness but I can't see that in the code.

Is there anyone who can kindly help me take a look at my code and comment on what else I can action to get this problem solved?

Thank you so much for your time!