adding or subtracting 1 to date field on button click

[splreece]

morning all,

ive googled and found lots of scripts on user specified dates but nothing on simply adding or subtracting 1 via a button click.


does anyone have recommendations on scripts or where to look.

it is important that I can cycle by day, so the user will also start on today, but I want 2 buttons, a +1 button and -1 button (therefore easily cycle through various days).

any thoughts?


PS the date field that governs all the formulae is in "H2".

All the calulations on the page link to a dataset and use H2 as the 'ifs' date identifier.

 

[portews]

Assign the button to this:

You can select any cell and change it by the button. If you specifically want to change H2, replace "ActiveCell" with "Range("H2")" in both places

Sub minusOne()
ActiveCell = ActiveCell - 1
End Sub