Trigger macro on cell change

It's late and I'm struggling to spot my error when trying to trigger a macro on a cell change.

I want to run a Macro called GraphScale when a cell value S79 is changed.

The cell value is changed via a combo box form control which is on the same worksheet as the macro and the target cell although the reference for the lookup is on another sheet.

My macro GraphScale does work but the macro to trigger it doesn't

So written as a private sub on the same worksheet as the form control and the target cell is

Please Login or Register  to view this content.

Any clues why this doesn't trigger?

Any and all help appreciated.

Ed

daffodil11,

Apologies if I'm being the dimmest of the dim but I've replaced my private sub code with yours and no cigar. I tried naming my form control combobox to see if that did anything but again no luck.

I'm pretty new to all this, am I doing something daft?

Massively appreciate the help by the way.

Ed

"You could also just directly assign your Graphscale macro to your form control combobox"

Did this, worked perfectly. Should have seen that myself but didn't.

Thank you stnkynts