Problems making VBA code to create start, pause & resume command

[shaunb84]

Hello,

I am using Excel 2007 to try and create a spreadsheet that tracks a person's time at work by using a series of start, pause and resume command buttons.

When an employee starts I want to be able to press a start button that counts and shows in another cell the calendar weeks said employee has been working (so far I have only been able to get my start button to count the time in seconds not weeks!).

I also need to be able to press a pause button if the employee is on holiday or sick that will stop the counting of the weeks until the employee returns to work, then I would like to be able to press the resume button to carry on counting the calendar weeks.

I have tried everything I can think of and tried searching the web, but I can't find anything to help me. I'm not even sure any more if this can be done. I would be eternally grateful for any help you can give me as my brain now hurts from the past week of trying to do this!

If I haven't made any sense, please feel free to ask for clarification!

Thanks

[Bob Phillips]

Doesn't a pencil and paper make more sense?

[Rob342]

Bob, i just love your comments, and i agree sometimes its easier with pen & paper, who invented VBA!

Shaun
Take the advice from the Expert (xld), but if you really want to learn,you can have a look at this post below, it might start you in the right diirection:

http://www.vbaexpress.com/forum/showthread.php?t=38988

rob

[Bob Phillips]

And it turns out he is cross-posting at XLGuru http://www.excelguru.ca/forums/showthread.php?457-Problems-making-VBA-code-to-create-start-pause-amp-resume-command

[Bob Phillips]

And here http://www.excelforum.com/excel-programming/793919-problems-making-vba-code-to-create-start-pause-and-resume-command-buttons.html

[Aussiebear]

When will people learn.......