Macro triggers event and leads to error

[Yonni]

Hi,

I currently have a workshet event that checks if a value entered a cell exists. It's quite simple and looks something like this (I've tried to remove the superfluous parts):

Please Login or Register  to view this content.

I have another macro that clears the values entered into the aforementioned cells and looks like this:

Please Login or Register  to view this content.

The two codes run fine indipendantly of each other but, with them both in my code, I guess a type mismatch everytime the macro 'clear' runs. I'm sure there's a reasonable explanation as to why this is happening but I'm stumped.

[Tsjallie]

Without the workbook it's hard to say what's the problem.
But it could well be that the Worksheet_Change sub is triggering the change event and thus calling itself endlessly.
Try to disable event handling at the start of the procedure and switch it back on in the end.
Something like this:

Please Login or Register  to view this content.

[Yonni]

Awesome. Disabling events worked.

Thanks a ton for the quick response