If statement VBA

[michaelp1029]

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.

Danke

 

[Gettingbetter]

Heres the code you would need,

Draw a textbox and assign this macro to it

Sub Checkfigures()
If Sheets("Sheet1").Range("J7") = Sheets("Sheet2").Range("D21") Then
  MsgBox "Everything is OK", , "OK"
Else
  MsgBox "Numbers don't match. Please verify", , "Verify"
End If
End Sub

Cheers
GB

 

[jeffreybrown]

Try...

Sub CheckValues()
    If Sheets("Sheet1").Range("J7").Value = Sheets("Sheet2").Range("D21").Value Then
    MsgBox "OK"
    Else
    MsgBox "Numbers don't match. Please verify"
    End If
End Sub

 

[michaelp1029]

Works superbly. Many thanks