Combo box iif conditions -role match sum

[mohitmadan]

Hi everyone , need some help on iif conditions , i have three combo boxes with 3 values like 1st combo has value proficient , expert and advanced. Other two combos also has the same values.
Let's say if I assign numeric values to Proficient = 20 , Advanced = 30 and Expert as 50



Now if a user selects 3 combo boxes with let's say 1st combo -->Proficient 2nd combo--> Advanced and 3rd combo--> Expert the result should be populated in a new textbox as "100" and also for other combinations as per user selection.. can anyone help

[Welshgasman]

Bring those values in into another column, and then just sum the selections with that column.
Put them into a table, so you cnage change the values easliy without having to modify code.

[mohitmadan]

Could you please explain more how to do that

[June7]

Do you know how to set a combobox to have multiple columns? Is combobox RowSource a ValueList or a Table/Query?

Say each combobox RowSource has the number values in second column, add the columns in a textbox by referencing those columns by index. Index begins with 0 so second column would be index 1.

=cbxOne.Column(1) + cbxTwo.Column(1) + cbxThree.Column(1)