Asked by duncanb7
at 2024-06-17 13:54:59
Point:500 Replies:5 POST_ID:828347USER_ID:11059
Topic:
Microsoft Excel Spreadsheet Software;;
I would like to have a timer function in VB for Excel Application to check hwo much time of my code
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
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
