Chose value of a cell depending on selections

[tharindudk]

Hi,

I ned to change value of a cell to "Complex" to "Simples" depending on the values they chose from drop down boxes. I have attached my code. But it works independantly. I want it to work together. eg at the moment lets say if A = NO its complex, or If B is Yes its Complex. So if A is selected as No but B is selected as No as well, it should still be Complex and this should be an or function. If either of these conditions are not valid then it should be simplex. Any help is much appreciated.

Please Login or Register  to view this content.

[Norie]

Can you explain the rest of the criteria?

Also, what are A and B - you seem to checking various ranges in the code for 'YES/NO'?

[tharindudk]

Oh no A and B are just examples.

so prety much

Please Login or Register  to view this content.

So either of them are these values its complex else Simplex


I want the code to check if the selections have been changed thats why i decided to use

Please Login or Register  to view this content.

[Norie]

If you wanted to check the values in those ranges at the same time you could use this, but I'm not sure if that's what you want to do.

Please Login or Register  to view this content.