Hi, all:

I have a worksheet which requires cell A1 value must be = 0. My macro
will pop up an ERROR message if this value is 0. The user must fix
this value to 0 before other coding was compiled. How to fix this?

here is my code:

Sub Test()

if worksheets("Sheet1").Range("A1").value 0 Then

msgbox"This value must be 0. Please fix before proceeding",vbcritical,
"Must fix the value before proceeding"

End if

Other coding ..........

End Sub