Trigger a public function in a module from a datepicker change

I have been cobbling together various bits of code from the web and trying to teach myself some VBA on the way and have the following problem:

I am trying to sum a row and this row has datepickers associated with it to show/hide columns based on the selection made. SUBTOTAL is no good as this will only work in the vertical so this is as far as I have got.


I have found the following code (now located in a module) that allows me to achieve the above but the SUM value (=SumVisible(G8:XY8)) will only update when a new cell is selected. I would like it to happen when the datepicker selection is made.

Please Login or Register  to view this content.

So I think I need to link this somehow into my datepicker code (shown below and located with a worksheet) but am at a loss.

Please Login or Register  to view this content.

Cheers in advance