Saving current time with macro

[marttikoo]

Hey,

I need to create macro that saves current time on new line (on same row) each time macro runs. Click button -> time is saved, click again time is saved on next line etc.

Im familiar with Excel (not expert) and total beginner with VBA. Im using Excel 2012.

Thanks

[alansidman]

try this:

Please Login or Register  to view this content.

Attach this to a Command Button

[MarvinP]

Hi marttikoo and welcome to the forum,

See the attached that has what I think you want. Click on a cell and then on the button. It will add the current time to the last column cell in that row.

[marttikoo]

Thank you for very fast answers.

MarvinP: Yes its pretty close for what I need. It would be perfect if it adds time last line in specified column (A for example). Like going from up to down, not sideways. And not needing to click to select column. After that I think I can modify code to make buttons for colunms B, C etc.

Thanks,

[marttikoo]

Got my code working with few trials and errors. Thank you for helping.