Worksheet_Selection Change problem

Hi folks,

I wrote this code which allows me to:
-- enter the DATE, then have the DESIGNATION column fill in automatically.
-- enter the CHARGE amount and have the CREDITS column fill in $0.00, giving me the option to
overwrite it if there is an actual credit to be posted.

I would like to run the "Clear_NONFOODS" macro w/o having zero's replaced everywhere,
and to be able to Right Click and Clear Contents w/o the having the same problem.
I'm wondering if there is a better way to achieve this?

Is it possible to also have DESIGNATION columns clear if the TARGET cell is cleared?
(This column will be hidden . It is used primarily for sorting when combined with other sheets on to a TOTALS page)

Please Login or Register  to view this content.

I’ve included a workbook for inspection.

Thanks!

Like so:

Please Login or Register  to view this content.

The EnableEvents function controls OTHER macros triggering. Turning it off lets it run its code without other macros triggering on there own, which is what is happening.

Also consider:

Please Login or Register  to view this content.

EDIT on the macro suggested post #5:

Please Login or Register  to view this content.

Huron & JBeaucaire: Adding the App Events for the Clear_NONFOODS Macro worked - Thanks.

Huron & JBeaucaire: Your codes work except when I right click and clear selected rows. Then I get an Error #13 Mismatch at this line:

Please Login or Register  to view this content.

Thanks.
Mark

Maybe add this to the top:

Please Login or Register  to view this content.

Let's see your complete code again. Perhaps you're turning off Events, then Exiting the Sub without turning it back on again.

Yep, that's exactly what you did. You turn off events in line 6, then put my Exit Sub (quick quit) in row 9 without turning events back on. Oops. If those events occur in that sequence, you've turned of all macros for good.

In post 10, I indicated to put that quit at the top, not line 10. Move it to line 2 and that will offer the quick quit before we've even done anything else.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)