dim sngStart as single dim sngEnd as single ..... sngStart=timer 导入的代码 sngEnd=timer msgbox "共用了" & sngStart-sngEnd & "秒" .....
应该用API timegettime之类的会更好
Private Declare Function timeGetTime Lib "winmm.dll" () As Long Sub Mysub() dim TimeCost TimeCost=timeGetTime ... '你的代码 ... ... ... TimeCost=(timeGetTime-TimeCost)/1000 MsgBox "运算耗时:" & TimeCost & "秒" End Sub
dim sngEnd as single
.....
sngStart=timer
导入的代码
sngEnd=timer
msgbox "共用了" & sngStart-sngEnd & "秒"
.....
timegettime之类的会更好
Sub Mysub()
dim TimeCost
TimeCost=timeGetTime
... '你的代码
...
...
...
TimeCost=(timeGetTime-TimeCost)/1000
MsgBox "运算耗时:" & TimeCost & "秒"
End Sub