Code repeats twice

[scurveydog]

Hello,

I have created an excel sheet to help our employees select the right product for the customer. The first part of the code clears a cell when the employee makes a change to cell A23. The second part of the code operates perfectly when the employee makes changes to any cell other than A23. When the employee changes cell A23, the second part of the code executes twice displaying "Please select another product. Cannot meet the current load!" and "Please select another product." two times in a row.

Why does it do this?
Any help would be very appreciated.

My code is shown below:

Please Login or Register  to view this content.

[romperstomper]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[scurveydog]

I apologize. I did remember that I was supposed to put tags around the code, but for whatever reason I could not find the tag button. Thank-you for telling me how to do this.

My code now has tags around it. I hope this helps everyone.

[shg]

I don't klnow what logic you're trying to implement; maybe this:

Please Login or Register  to view this content.

[scurveydog]

Sorry I forgot to add a sentence. Please see the code above for the update.

I will try to clarify this. When I run the first and second part of the code separately they work fine. The first part of the code clears cell A23 when the user makes a change to the spreadsheet. The second part of the code will display "Please select another product. Cannot meet the current load!" if cell E44 is bigger than cell E41 and will display "Please select another product. Product is too small."
or "Please select another product. Product is too big." if cell E30 is less than 10 or greater than 22 respectively. Nothing is displayed if the value in cell E30 is in between 10 and 22.

However, when I run the first part and the second part of the code together "Please select another product. Cannot meet the current load!" and "Please select another product. Product is too small." is displayed (if E30 is less than 10) and will repeat itself twice such as:
"Please select another product. Cannot meet the current load!"
"Please select another product. Product is too small."
"Please select another product. Cannot meet the current load!"
"Please select another product. Product is too small."


OR

Please select another product. Cannot meet the current load!" and "Please select another product. Product is too big." is displayed (if E30 is greater than 22) and will repeat itself twice such as:
Please select another product. Cannot meet the current load!"
"Please select another product. Product is too big."
Please select another product. Cannot meet the current load!"
"Please select another product. Product is too big."

OR

"Please select another product. Cannot meet the current load!" is displayed (if E30 falls between 10 and 22.) and will repeat itself twice such as:
"Please select another product. Cannot meet the current load!"
"Please select another product. Cannot meet the current load!"

I hope this clarifies my problem. I don't want it to display the message twice. (once is good enough).
Let me know if it is still confusing and tell me what you don't understand.

[romperstomper]

I suspect you just need to disable events, since you are changing the sheet from the Change event:

Please Login or Register  to view this content.

[scurveydog]

Perfect!!! That's exactly what I wanted. Thanks a lot.