G
George
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
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