vba to add year to a cell, then be able to increase or decrease year to suite need

I have a range of cells, O10:O24 which I would like to be able to enter the year in, then be able to adjust this by doubleclicking and rightclicking the mouse. These three vba's work, but is there a better way to do this? Thanks!

Please Login or Register  to view this content.

It is not necessarily better, the only other thing I could think of would be to use spin buttons

Thanks stnkynts, cough, cough (joking). I am now thinking of just using doubleclick to insert the date and rightclick to reduce it. Is there a way to do this so that it enters this year plus 10? I tried "now + 10", but it gave me the time and this year in the cell. I don't really want to have to go back to the macro every year to add one.

This is how you would enter this year plus 10 years upon double clicking a cell.

Please Login or Register  to view this content.

Awesome, thanks!