Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
Timer in VBA Excel 2003

function and subroutine is used. For example, timer function call timer_fn() insert my code to monitor
the time to be used. Please review following code as my wish
Sub Mycode(0
Dim start as integer or time
Dim finsih as interger or time
Range("A1")= Timer_fn(start) ' Start COunt
Dim i as interger
For i to 100000000
donevent
next i
Range ("B1")=Timer_fin(finish) 'Count is finished
Range ("C")= Range("A1")-Range("B1")
format(Range"C") 'as in minutes or seconds for user display purpose
End Sub
Please advise any good timer function and website for this part or tutorial
Duncan
You can also use the Timer function which returns a floating point value of the amount of seconds past midnight with a resolution of 1/100 of a second.
x = Timer
'some code to execute
elapsedTime = Timer - x
You can also use the Timer function which returns a floating point value of the amount of seconds past midnight with a resolution of 1/100 of a second.
x = Timer
'some code to execute
elapsedTime = Timer - x
You can also use the Timer function which returns a floating point value of the amount of seconds past midnight with a resolution of 1/100 of a second.
x = Timer
'some code to execute
elapsedTime = Timer - x
You can also use the Timer function which returns a floating point value of the amount of seconds past midnight with a resolution of 1/100 of a second.
x = Timer
'some code to execute
elapsedTime = Timer - x