How do I increase conditions in a Case argument??

[bralew]

Morning All,

I've written this code which selects parts based on 3 variables but realised there's another consideration which requires insertion.
I need to insert the consideration 'If ComboBox42 says "Conical" also.
Any ideas how I can do this?

Thank You

Please Login or Register  to view this content.

[xlnitwit]

If you mean to add that condition to the existing If clause, you need only And it into the line thus

Please Login or Register  to view this content.

[bralew]

Ah good man, Its works fine. Just one more thing, in the box which contains Conical there are only two variables: Conical and spherical,

The userform defaults at Conical and the above code works fine. However, if I change to Spherical and insert the other conditions, and then change to Conical, it doesn't change?

In other words, the conical/spherical will produce different outcomes which I'll need to switch between. Sorry to be a pain:-/

[xlnitwit]

Changing combobox42 is not going to trigger a change event for combobox17 unless combobox42 changes combobox 17 as well. You need all the relevant controls (comboboxes 7, 17 and 42) to call a routine to update the other controls. I'd also suggest that a good naming convention would make your code more intelligible and thus more maintainable.

[bralew]

Ok, thank you for that. I'm unsure at the moment how to tackle the logic, but it works for now. Thanks xlnitwit