ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   enter time when shape is clicked (https://www.excelbanter.com/excel-discussion-misc-queries/206358-enter-time-when-shape-clicked.html)

Dgwood90

enter time when shape is clicked
 
I want users to click a shape when they are done entering data, so that the
current time is entered into another cell.

Gary''s Student

enter time when shape is clicked
 
Assign the following macro to the Shape:

Sub timeIt()
Range("B9").Value = Time()
End Sub

Adjust the address to suit.
--
Gary''s Student - gsnu200806


All times are GMT +1. The time now is 12:06 AM.

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