Consulting

Results 1 to 1 of 1

Thread: Out of Stack Space Runtime Error 28 in MAC Excel 2011 VBA

  1. #1
    VBAX Newbie
    Joined
    Nov 2015
    Posts
    1
    Location

    Out of Stack Space Runtime Error 28 in MAC Excel 2011 VBA

    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!
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •