Use BeforeDoubleClick to sum cells

[dodde]

Hello

I have column L and it will be various of number of rows, is it possible to use doubleclick in cell L20, L21 and so on to sum M17+M16+M14, and sum it in cell L20, L21and so on, or must i use another emty cell to double click in for each row and how will that vba look like

The values in M17, 16 and 14 will change often

[JohnTopley]

Please Login or Register  to view this content.

Right click on tab, "viw Code" and copy/paste above code

[dodde]

Hello

Just perfect

[dodde]

Hello

I did a little change so it only sum when double click column L

Please Login or Register  to view this content.