Try This ...

If Range("A1").FormulaR1C1 <> 0 Then
'run your code here
ActiveWindow.SelectedSheets.PrintPreview
Else
MsgBox ("Cell [A1] cannot equal Zero")
End If

regards, Nick

"Neil Jimack" wrote:

> I have a macro assigned to a button, but it can only run if a particular cell
> is zero. If the cell is greater than or less than zero, I want a message box
> to appear telling the user that the cell in question isn't zero.
>
> I know the code for making the Msgbox appear, but don't know the syntax for
> only having the box appear if the cell in question isn't zero.
>
> Any advice?