>
> Can u please help me in writing a macro in excel as below:
>
> 1) When we click on the command button, it should prompt for entering
> the employee number in the input box.
>
> 2) After entering the employee number, it should take us to the cell that
> has
> the number.
>
> 3) and corresponding cell should be filled with current time.
>
> Template is as below:
>
> When i click the command button and enter the number 307304 in the
> input box. it should take me to the particular cell and that start
> time should be captured. if i click again end time should be captured.
> (these times should be current time).
>
> Employee # Start Time End Time
> 307301
> 307302
> 307303
> 307304
> 307305
> 307306
> 307307
> 307308
> 307309
> 307310

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Attachment: break timing.xls
Description: MS-Excel spreadsheet

Reply via email to