VBA中的误差错误处理恢复下

此宏代码使下一步对错误恢复功能。

解释

为了使有关错误恢复下一步将跳过的VBA程序代码,通常会产生一个错误,停止该程序。

一个基本的VBA宏的例子可供下载的文件是在本网页的底部,或只是复制和粘贴从这个网页上的代码直接。

Public Sub Error_Handling_VBA_On_Error_Resume_Next()

'The error function is turned off in case of error just continue
On Error Resume Next

'An error statment is trying to be executed and no error occurs due to On Error Resume Next
Test = 5 / 0

'Normal error handling is turned on again
On Error GoTo 0

End Sub



 

 

 

下载Excel文件!VBA_Error_Handling_On_Error_Resume_Next.xls

 

Add your comment

Your name:
Subject:
Comment: