How Do I create a clickable Timestamp button

**bookwrm** · 05-10-2012, 12:31 AM

I love Excel...

I have all kinds of timestamps in my workbooks using VB editor, but they all require you to enter a character into the cell in order to show the timestamp. The one thing I cannot seem to find anywhere is how do I create a time stamp that is activated by merely clicking a button. Lets say I create a hyperlink button that you click and the next cell over shows the timestamp. Even if its just a cell that you click, (i.e., click any cell in column A and the same row in column B will show the timestamp

Thanks for the help
RC

**AlvaroSiza** · 05-10-2012, 01:04 AM

The following would place a timestamp in Cell A1. You can modify as needed to tie it to a button or include within a worksheet_SelectionChange event.

Please Login or Register  to view this content.

**scubacamper** · 09-07-2012, 03:42 PM

How do you edit the "A1" cell to the "next available cell in column C"? (Excel novice)

**Cutter** · 09-08-2012, 07:38 AM

Hello scubacamper, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**Jacc** · 09-08-2012, 08:54 AM

Originally Posted by bookwrm

I have all kinds of timestamps in my workbooks using VB editor, but they all require you to enter a character into the cell in order to show the timestamp. RC

I'm not sure what you mean by this.
Also I'm not sure about exactly what you are after.
And even more important, I'm not sure about your skill level in Excel.
I'm just gonna make some assumptions and then you have to ask if you need further instructions.

How about a button that enters the date (or time) in selected cells?
I would put that button on my Quick Access Toolbar so that it doesn't go away with scrolling.

Please Login or Register  to view this content.

Paste any (or all) of the above in a Module in your Personal workbook, that way the function will always be accessible.

Choose "More commands" from the little arrow on your Quick Access Toolbar.
Choose "Macros" instead of "Popular Commands" in the dropdown menu.
You should then be able to choose a macro.