VBA unable to read values I guess

[Asheesh]

Hi Guys,

I am facing this weird issue, need your help

I am trying to compare two values and if they are not equal then give me a msgbox...but I don't know what is wrong here...

See the attached

If rValue <> oSum Then
  
  MsgBox "please check values", vbCritical

  End If

 

[Marc L]

Hi !

Not weird, just a bad variable type !

Try with Currency instead of Double …
​

 

[Asheesh]

Hey Mark,

Thanks worked like a charm !!

 

[Marc L]

Try also this demonstration …
​