Button to insert current time in active cell

[cinci-hal]

I am looking for a way to insert the current time in the active cell. I guess this would be done by clicking a button. Can someone give me a step-by-step explanation on how to do this or a step-by-step explanation of a better solution. I found one tutorial that I did not like that insert the current time in any cell I clicked in. This was not good because I would end up inserting the time in cells that did not intend to. I was thinking that clicking a button to insert the time in the active cell would give me the control I am looking for. I do not know hardly anything about working with developer tools so clear instructions would be appreciated.

[danny2000]

It's quiet simple. All you need to do is drag a button onto your spreadsheet and double click on it to bring up a wizard which will ask you to direct it to a macro or write a new one. You only have to add Activecell.value = time to the procedure and that's it.

Search around the web for how to add a button to your spreadsheet. Also look up events to understand how a small procedure is run from that button.

Example attached.

Please Login or Register  to view this content.

Time.xlsm

[cinci-hal]

I'm thinking now that I want to do something different. Instead of putting a button on the spreadsheet, I think it would be better to have a macro in the ribbon. I created a ribbon called time with a group called current time and inserted a command macro called time into it which has the script that you provided

Please Login or Register  to view this content.

When I put the cursor in the cell where I want the current time inserted and click on the time macro in the ribbon, I get an error:

Compile error:
Expected Function or variable

What am i doing wrong?

[JOHN H. DAVIS]

Change your Sub name. There is already a Function called time that is built-in to VBA. The very one you are using in your macro.

[cinci-hal]

Thank you for your help. I actually stumbled upon a solution that will work even better for me. I did not realize that there was a shortcut Ctrl+: that does what I want.