Ray Spackman
Registered User.
- Local time
- Today, 11:31
- Joined
- Feb 28, 2008
- Messages
- 52
This is a little confusing but I will try to make it clear. I have the controls on a form whose values are filled by the user; AR, BS, and RR. My vba code compares two of these values at any given time, not all three, and returns a determined value to another control on the form if the comparison specifications are met for two of the three values.
The Problem:
If the comparison specification for AR and RR are met, the retruned value is correct but if the comparison specifications for BS and RR are met in a different case statement, the returned value does not change because the original comparison of AR and RR can still also be true, therefor returning that original value. The same happens whencomapring AR and BS.
So I am wondering if there is a vba operator that will allow me two exclude the value of a specific control. For instance in the second example where AR could be excluded so that only BS and RR can be compared regardless of the value of AR.
If this is not possible, can someone show me some code using Case statement and/or If statements that will allow me remedy this problem.
As always Thank You in advance.
The Problem:
If the comparison specification for AR and RR are met, the retruned value is correct but if the comparison specifications for BS and RR are met in a different case statement, the returned value does not change because the original comparison of AR and RR can still also be true, therefor returning that original value. The same happens whencomapring AR and BS.
So I am wondering if there is a vba operator that will allow me two exclude the value of a specific control. For instance in the second example where AR could be excluded so that only BS and RR can be compared regardless of the value of AR.
If this is not possible, can someone show me some code using Case statement and/or If statements that will allow me remedy this problem.
As always Thank You in advance.