D Dgwood90 Oct 15, 2008 #1 I want users to click a shape when they are done entering data, so that the current time is entered into another cell.
I want users to click a shape when they are done entering data, so that the current time is entered into another cell.
G Gary''s Student Oct 15, 2008 #2 Assign the following macro to the Shape: Sub timeIt() Range("B9").Value = Time() End Sub Adjust the address to suit.
Assign the following macro to the Shape: Sub timeIt() Range("B9").Value = Time() End Sub Adjust the address to suit.