- Jul 15, 2008
So here's the deal. I need to develop an "if" statement in my VBA code. In cell J7 of "Sheet 1" I have a dollar value that should match the value in cell D21 on "Sheet 2". So I want to have a button that I can press and if J7 Sheet 1 and D21 Sheet 2 are not the same, I would like a message box to appear stating "Numbers don't match. Please verify". But if the are equal, I want another message box to appear stating "Ok". I am a novice at VBA and could use some help.