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 number in the input box.
2) After entering the number, it should take us to the cell that has the numer. 3) and coresponding 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
