sum with outcome to show userform

[donny1shot]

Hi All,
I am trying to create a vba code that shows a userform if C14 + C15 > C13. I have tried the below but it does not work.

If Range ("C14:C15").value > Range ("C13") then userform1.show

 

[louisH]

Hi.

One solution :

If (Range("C14").Value + Range("C15").Value) > Range ("C13").Value Then UserForm1.show

Another one :

If WorksheetFunction.Sum(Range("C14:C15")) > Range ("C13").Value Then UserForm1.show

 

[dave2018]

you forgot to add .value after Range("C13")

If Range ("C14:C15").value > Range ("C13").value then userform1.show


I think that should work...

Edit: ooops. that doesn't work either. my mistake.

 

[louisH]

you forgot to add .value after Range("C13")

If Range ("C14:C15").value > Range ("C13").value then userform1.show


I think that should work...

Range("C14:C15").Value

doesn't return the sum of the range but an array of the values in range, like : {1, 2}
If C14 = 1 and C15 = 2

 

[dave2018]

true. i got carried away for a sec.

 

[donny1shot]

got it thanks for the swift and accurate reply peeps.