MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Private Sub worksheet_deactivate() Dim varReturn varReturn = Evaluate("IF(AND(AND(OR(((F8-I8)/I8>0.2),((F8-I8)/I8<-0.2)),NOT(ISBLANK(I8)),NOT(ISBLANK(F8))),AND(NOT(ISBLANK(F8)),NOT(ISBLANK(G8)),NOT(ISBLANK(H8)),NOT(SUM(G8+H8)=F8))),TRUE,FALSE)") If Not IsError(varreturn) Then If varReturn Then MsgBox "Test", vbOKCancel End If End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|how can I remove vertical lines within an Excel spreadsheet while retaining hortizontal lines?||6||43|
|Excel - Active X Checkboxes Groups||45||36|
|need count all combination||31||31|
|Sort columns by the column header Excel 2016 VBA||5||12|
Join the community of 500,000 technology professionals and ask your questions.