Simple Timer

atmospheric

atmospheric

Well-known Member
Joined
Jul 16, 2002
Messages
565
Is it possible using formulae to create a simple count up timer along the lines (In A1) =B1+1 and in (B1) =A1+1 ? Obviously this will create a circular reference and get kicked out by Excel.

I would prefer to use a formula if possible, but if it's not, could one of you guys post the necessary code? Speed and accuracy don't matter.

This is to serve no other purpose than to run the b*ll*cks off my old pc to see how much it can handle.

Thanks in advance
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Don't think you can do it via formula as the # of iterations is limited.

Don't really know how to do it, other than put in a bunch of formulas which reference each other then have a looping code .Calculate
 
Upvote 0
If all you are looking for is the time it takes to run a procedure, the following will get you elapsed time.

Put this at the beginning of your procedure.
Start = Timer

code goes here...

Then at the end of your macro, put this.

Sheets("Sheet1").Range("D1").value = Timer - Start

Cell D1 will have the number of seconds it took to run the Macro.
 
Upvote 0
Hello,

If you want to stomp on your processor with no boundaries, try the following:

Code: 
Sub foobar()
Do:   DoEvents:   Loop
End Sub
Hit Ctrl-Break when you're done. :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Completely cleaning account numbers and storing with a specific format
Replies
2
Views
1K
diversification
D
C
  • Question Question
Create code that sends emails and creates a log
Replies
1
Views
315
cokeoverpepsi123
C
C
  • Question Question
Simple (I thought) loop, compare, copy and paste question from a somewhat VBA newbie.....
Replies
2
Views
812
chisercfc
C
X
  • Question Question
Creating Sheets from Column Using Template Sheet and Copy Cells to Created Sheet
2 3
Replies
26
Views
4K
xavier12
X
G
  • Question Question
Excel VBA Macro steps through ok but when run it causes duplication
Replies
2
Views
4K
Gassy
G

Forum statistics

Threads
1,224,872
Messages
6,181,498
Members
453,047
Latest member
charlie_odd

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top