ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Show Time Stamp in Cell when Command Button Clicked (https://www.excelbanter.com/excel-programming/404549-show-time-stamp-cell-when-command-button-clicked.html)

RyanH

Show Time Stamp in Cell when Command Button Clicked
 
I have a command button on a worksheet that moves certain dates forward by
one week. The user should only click this button at the beginning of every
work week. Is there a way to show the date in a cell next to the command
button when the command button was clicked?

Thanks for your help in advance!
Ryan

Sam Wilson

Show Time Stamp in Cell when Command Button Clicked
 
Range("a1").value = now()

will work

"RyanH" wrote:

I have a command button on a worksheet that moves certain dates forward by
one week. The user should only click this button at the beginning of every
work week. Is there a way to show the date in a cell next to the command
button when the command button was clicked?

Thanks for your help in advance!
Ryan



All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com