Program running 4 times instead of once, Work around?

[MGARDNER]

Hi Guys, I'm new to the forum so please excuse me if I mess anything up.

I'm wondering how to get a certain program to only run once? The following code continues to loop 4 times which is a nuisance due to various pop up msgboxs. Any ideas?

Please Login or Register  to view this content.

The second issue is that each time the user updates any of the radio buttons, the program will re perform all the calculations. Is there any way to ignore certain button selections in the worksheet_change sub?

Thanks in advance.
-Myles

[MGARDNER]

BUMP, Anyone? Is there not enough info?

[Norie]

Myles

I don't think you've posted all the code.

In what you have posted other subs are being called, and those subs call other subs.

There could be code in any of those subs that is changing the worksheet, and therefore triggering the change event.

If that is the problem what you could do is add this in the Change event just before you call the other subs.

Please Login or Register  to view this content.

If you do use that it's important to enable events again:

Please Login or Register  to view this content.

[MGARDNER]

Thank you very much, I was able to use the enableevents to get it to correctly run the first time, but if user updates after the initial run, noting happens. Am I using this correctly?

Here is what I have so far:

Please Login or Register  to view this content.

Thank you very very much for the help!
-Myles