Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

**Jenn68** · 01-10-2019, 04:12 PM

I have a userform that worked wonderfully without error when it was limited to functionality associated to one accessible toggle button ("OPS") to the user. Today, I introduced two more toggle buttons ("WEATHER"; "AVL"), each with click event handlers.

When the user clicks on the first (oldest) button, and then clicks on one of the other two buttons, I receive an "Out of stack space error". If I restart, and this time select one of the two newer buttons, then go over the the first original button I get the same error. I do not get this error if I limit button pushes to the two newer buttons, but as soon as I introduce the first button ("OPS") I get the "Out of stack space error."

When I debug, it brings me to this line of code (in red), which I don't think to be a major contributor because it had not created an error before the introduction of the two new buttons.

Please Login or Register  to view this content.

I will post some code that may or may not be relevant. I can certainly provide the file should anyone wish to pursue the problem outside of the code I've provided.

The "OPS" toggle button click event code:

Please Login or Register  to view this content.

The "WEATHER" toggle button click event code:

Please Login or Register  to view this content.

The "AVL" toggle button click event code:

Please Login or Register  to view this content.

Any and all help is appreciated. This is resulting in a significant loss of full functionality in my project so I hope there is an easy fix.

**Bernie Deitrick** · 01-10-2019, 05:29 PM

Post the workbook - to check your code would require a lot of extra work...

**Jenn68** · 01-11-2019, 07:57 AM

Hello Bernie, thank you!
With the hope that the problem can be identified and easily resolved, I've attached a link to download the file.

REMOVED

To recreate the error* open the file giving it permissions for the macros. It should open to sheet2 of the workbook and launch userform1.
On userform1, click the "OPS" button. Follow that with a click of either the "WEATHER" or "AVL" buttons. This should create the out of stack space error*. Debug will take you to the line in my original post highlighted.
For testing purposes (as this application relies on public variables loaded on workbook opening), simply click the smiley face on sheet2 to relaunch the userform. No need to close reopen the workbook.
You will not get this error clicking only between the "WEATHER" and "AVL" buttons. As soon as you include "OPS" button at any point you get the error.

* When I took this file home (vs. work) overnight, I did not immediately receive the "out of stack space error". Unfortunately, I did not manage to write down the message to share. With further testing, the "out of stack space error" eventually did crop up. The errors eventually made the system unstable. In fact, (and this is both unusual and scary), during testing when the error was encountered, EXCEL shut down. The computer was stable, but EXCEL closed. I had to restart Excel, but ... the file was no longer on my media. It was gone. I even did a data recovery of the thumbdrive with no luck. (Luckily I had the file backed up at work). The file must have become corrupted as I later found remnants of it ... ~$18-19 Materials Track.xlsm.

**Norie** · 01-11-2019, 08:32 AM

Jenny

When you get the error have a look at the Call Stack (CTRL+L).

**Jenn68** · 01-11-2019, 08:42 AM

Oh, hello Norie!

What should I be looking for there ...

Capture.JPG

**Norie** · 01-11-2019, 08:55 AM

There's a bunch of calls to various click events that probably aren't needed.

For example, the call to the Ops click event.

Now the reason that event is being triggered is because you set the value of that control to False in the code for the Weather button.

One way to prevent the problem would be to set mbEvents to False before you change the value of Ops and change mbEvents back to True afterwards.

**Jenn68** · 01-11-2019, 08:57 AM

I figured it out.
From within the toggle button changes, I was changing the value of the same button being pushed, so it was like it was in a constant loop of repeating states.

Please Login or Register  to view this content.

**Jenn68** · 01-11-2019, 09:05 AM

Thanks Norie!!! Working so much better than it did last night.
Thank you all for your interest in helping.

**Bernie Deitrick** · 01-11-2019, 10:05 AM

Well, I just got to work - and I'm happy to hear that you got it all figured out.

Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

LinkBack

Thread Tools

Rate This Thread

Display

Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Re: Out Of Stack Space Error With Toggle Button Clicks - One Problem Button

Thread Information

Users Browsing this Thread

Similar Threads

toggle button problem

Combining separate button functions into one toggle button 2011 office for mac

Toggle Button on/off problem

Toggle Button on Workbook Open - value is True but button not pressed?

[SOLVED] Toggle Button 'State' Problem on Workbook Open

TOGGLE BUTTON on userform problem

Adding .xla button for Toggle Calculation Button

Bookmarks

Bookmarks

Posting Permissions