1 CommandButton to Start and End timestamp

[darkhangelsk]

Hi,

I know that we can easily create a timestamp using a command button:

Please Login or Register  to view this content.

that's the start time, so how about i'm gonna use the same button to end the time, and once the start and end time has value if you click the same commandbutton there should nothing happen because there's already a value.

really appreciate any inputs.

[mehmetcik]

Hi

Please provide cell ref for start time and cell reference for end time

Also why use a button when you can use a double click?

[darkhangelsk]

Hi mehmetcik, thanks for the response..

well i'll use a button because of i'm going to protect the worksheet. i'd rather have this vb code:

Please Login or Register  to view this content.

where c2 is the start time.. and c3 for the end time.

Thanks.!

[darkhangelsk]

I know it's possible.. please help me guys

[darkhangelsk]

anyone?????

[mehmetcik]

Please Login or Register  to view this content.

[darkhangelsk]

works perfectly! Thanks man!