Issue:
I have multiple optionbuttons and tickboxes which change calculations, however when pressed or selected they do not activate the Worksheet_Change sub - in which the calculations are performed.
I need to somehow catch all activex events (from these boxes and buttons) and call the worksheet change event when they occur
The product will be used by someone else going forward thus I'd prefer not to place calls in all the boxes and buttons sub's (in case of later additions/ changes) but rather have an "ActiveX_Change" routine equivalent to the Worksheet_Change one.
I have looked at several different options, but haven't been able to identify a way to do it globally. Is there someone out there with more experience? :)
Also am unsure but if there is some sort of event handler code for this, where should it be placed to be sure it is always considered?
Thank you very much for your help!
Best, Max
Aucun commentaire:
Enregistrer un commentaire