Spin up spin down for cell date + 6am time

[aaron061883]

I need help setting up a macro spin up spin down button to change the date in cell F5 by 1 day.
3/15/19 6:00am spin up spin down to change the date to 3/14 or 3/16 and so on.
Any help to make this happen would be greatly appreciated.

[Roel Jongman]

you dont need VBA to control the spinbutton.

All you need to do is set a linked cell and have that value added to a set startdate in
you do that thru the right-click menu item Format control on the control tab
spin buttons are limited to values between 0 and 30.000
since 2019 dates are in the 43000 range, so you cannot link to the date cell directly

you need to link to a helper cell you could hide under the spinbutton and have that helpervalue of the spinbutton added to a startdate like so

Please Login or Register  to view this content.

15 march is reached with value 73 in D1

(for the example I put the linked cell in the visible D1 to see it work)

[dotchiejack]

Or if you use an activeX spinbutton

Please Login or Register  to view this content.