tricky if command

Hi,

Can anyone help out. I would like to add the contents of Combobox 7 and Combobox23 and the number 30 if the contents of combobox5:

is 75,
35 if the contents Combobox5 is 127 or
30 if the Contents of Combobox5 is 75

The answer to be placed in Combobox19

Any help would be gratefully received.

This code has been greatly assisted by Kenneth.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

One small tweak, to prevent adding duplicate items in ComboBox19:

Please Login or Register  to view this content.

select 54sq Square at the first user form

Select Hub A, in the Hub box and 75 in the Drop Arm centres box and the H factor box reports 30 instead of 142?

How are you reaching your required outcome of 142?

In the scenario you describe, ComboBox7 has a value of "A 71", and ComboBox23 has a value of "A 71". These are both strings, so cannot be added up as a number.

So you want to convert the strings to values - removing the "A " part, and only considering the "71" ?

Looking at your combobox list values, it appears it would only ever be 41 or 71 - so you could change the code to:

Please Login or Register  to view this content.

Can I offer a couple of bits of advice?
1. Use Select Case throughout your code, instead of If statements.
2. Rename your forms and form controls to something more meaningful.

Maybe:

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.