VBA Count down timer improvements

**Bob-1383** · 09-14-2014, 06:19 PM

Good evening

Found a count down timer on this site and it works, but have been trying to make improvements to but so far im not successful. (After 2 weeks )

1. Im trying to get all the cells to start count at =NOW at the same time and not have to select each one. (Tried to record a macro to select all the field to start at same time however the USERFORM 1 does not allow this.)

2. Trying to add a stop function(Button) that does not clear the time, just displays the time at the moment it was stopped.

Help would be appreciated as my VBA knowledge is near non existant, i have attached the file.

Count Down Test.xls

**mehmetcik** · 09-14-2014, 08:39 PM

I have added a second stop function for you.

Also set the count up as default

**Bob-1383** · 09-15-2014, 05:06 AM

The default helps thank you, however it seems the second stop function does not work. Could this be due to different versions of excel?

**mehmetcik** · 09-15-2014, 12:18 PM

It should work. I have simply copied code from your worksheet. It works for Office 2013.

**Bob-1383** · 09-16-2014, 01:47 PM

It works thank you

, how do i change it to stop only one selected line at a time.
I have tried to copy the start code and edit it but I cannot change it to work for stopping a single line at a time

. Frustrating if you havent studied this.

VBA Count down timer improvements

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA Count down timer improvements

Re: VBA Count down timer improvements

Re: VBA Count down timer improvements

Re: VBA Count down timer improvements

Re: VBA Count down timer improvements

Thread Information

Users Browsing this Thread

Similar Threads

COunt down timer help please.....

count down timer

Count down time and count up timer does not starts in another sheet(s)

Count down time and count up timer does not starts in another sheet(s)

count down timer

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions