how to date stamp with form function macro?

[PlumGr8]

Hey guys, been a long time lurker finding my answers, but can't find one for this one, so here goes.

Creating a tracker tab using the spin function, where i click up or down to increase or decrease a value. I am looking for a way that everytime i click the spin function that it will auto date stamp a selected cell. I tried a couple formulas that i found on auto stamping a date when a cell value changes, but it won't work when linked to the spin function it seems. So i see i can add a macro into the spin function, so not sure if i can do it that way?

So basically, i would hit the top button on the spin function to increase the value in say D6 from 10 to 11. I would like it if i could then make cell D7 show the date stamp for when it was changed. Is there an easy way to do that?

 

[MikesyM]

hi PlumGr8,



Think you need a code like this (obviously replacing "Tracker" and "A1" with the sheet and range you want):

Sub TrackChange()

ActiveWorkbook.Sheets("Tracker").Range("A1").Value = Now

End Sub

And then assign your spinbutton (right-click menu) your new macro 'TrackChange'

I hope this helps you achieve what you expected.

 

[PlumGr8]

Thanks, i had to modify it a little bit, i actually had 9 spin functions to assign, but we used that as the basis and we got it. Thanks for the help