sum or subtraction based on selected item from combobox on userform

[Mussa]

Hello
I want matching selected comboboxes on userform with sheet B: E and summing or subtraction based on selected from combobox 13
so the numbers for comboboxes & textboxes will be for each row on userform like this
combobox1 combobox2 combobox3 combobox4 ,textbox1
combobox5 combobox6 combobox7 combobox8,textbox2
combobox9 combobox10 combobox11 combobox12,textbox3


so when select SALES from combobox 13 SALES and fill userfrom as in CON1 sheet
so should subtract the QTY from textboxes to column F


when select RET1 from combobox 13 as in CON2 sheet
so should subtract the QTY from textboxes to column F




when select PURCHASE from combobox13 and fill userfrom as in CON3 sheet

so should summing the QTY from textboxes to column F
to become in column F



when select when select RET2 from combobox13 as in as in CON4 sheet

so should summing the QTY from textboxes to column F
to become in column F


so I put the cases in sheets(con1,2,3,4)
here is file
Dropbox
thanks

 

[SunnyAlv]

Is there any relation between the table in 'Sheet1' and the sheet 'Stock'?

 

[Mussa]

Hi,
just work for STOCK sheet , ignore Sheet1 .

 

[Mussa]

Hey ,
did you see my comment ?!