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?