ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 756
- Office Version
- 365
- Platform
- Windows
I'd like to see how this can be done in VBA, without actually using any formulas in the worksheet.
IF the value in P10 = D9*E9, the word "OK" should appear in Q10.
This "OK" in Q10 would be triggered as soon as the entry is made in P10.
Essentially it is the same as having =IF(D9*E9=P10,"OK","") in Q10, except I want the formula in VBA rather than in cell Q10.
Thanks, CJ
IF the value in P10 = D9*E9, the word "OK" should appear in Q10.
This "OK" in Q10 would be triggered as soon as the entry is made in P10.
Essentially it is the same as having =IF(D9*E9=P10,"OK","") in Q10, except I want the formula in VBA rather than in cell Q10.
Thanks, CJ