Change event applied to all textboxes

Hi

I have created a textbox change event that calls a sub. My sheet will end up with many textboxes so I'd like to simplify this so that when any text box changes it calls the sub so that I don't have to add the code to each textbox change event. I've found lots of posts similar to this when working with userforms and textboxes that have simple naming conventions but haven't managed to make anything work for my scenario. My textboxes have varied names with no pattern.

Can anyone help?

Please Login or Register  to view this content.

Thanks very much,
Jo

Yes, they're ActiveX text boxes on a worksheet created by a macro:

Please Login or Register  to view this content.

Hi Jindon,

Sorry for the delayed response! This works beautifully, thanks so much! The only slight problem is that on two of the five sheets that use this code I get a type mismatch error 13 on the below line of code:

Please Login or Register  to view this content.

Any idea how to stop this? I had a try myself but can't seem to see what's causing the error.

Thanks
Jo