Quote:
Originally Posted by shield5
Hi
In cell A1 I have a dropdown list using the validation list type. In cell E1 I have a True or False formula. For example if the values 10, 20 and 30 in the dropdown list correspond to True, I want the macro to tell the dropdown list to stop its run at the value 30 and not move to the value 40 which would correspond to False, Also how could I repeat the macro for the following rows?
Thanks
|
Not quite sure here. Let me inform you with what I understand so far.
Quote:
|
In cell A1 I have a dropdown list using the validation list type.
|
Im assuming this means you have a validation list of 10, 20, 30, 40 etc. that you can select from.
Quote:
|
In cell E1 I have a True or False formula.
|
Sounds like an if formula.
Quote:
|
For example if the values 10, 20 and 30 in the dropdown list correspond to True,
|
Already lost here. Cell A1 has a value from 10 - 90 or some other range Your if formula seems to check if the value in A1 is greater than or Less than another value yet this some how refers to true?
Quote:
|
I want the macro to tell the dropdown list to stop its run at the value 30 and not move to the value 40 which would correspond to False, Also how could I repeat the macro for the following rows?
|
I would need to understand the if formula you are using from the first confusion point to go further.
Let me know.