add & subtract values from userform to specific column in sheet

hi, i have this code for mr. sintek i would amending by make it add & subtract values i have two userform first add values to col e and the same thing the userform 2 but subtract when i use data from multiple combobox based on data in sheet1 from a2:d and fill the value in textbox should change this brand add as in userform1 or subtract as userform2

HTML Code: 

not too clear what you are wanting to do.
the code just adds another complete row of a combination of your comboboxes and textbox.
Are you in fact wanting to increase or decrease the value in column E ????
torachan.

hi, torachan

Originally Posted by torachan

not too clear what you are wanting to do.
the code just adds another complete row of a combination of your comboboxes and textbox.
Are you in fact wanting to increase or decrease the value in column E ????
torachan.

yes , i'm wanting do that when i choose from multiple combox if is already existed then just increase by userform1 or decrease by userform2 and if data not existed then add data in lastrow
i hope this help

your approach to the problem is somewhat alien to me.
do you have 3 brands with the same code.
you need some method to check if item is list before entry to prevent duplicates.
this appears a typical stock control excerise, first establish your stock descriptions, codes etc.
then apply a stock in/out/balance procedure.

thanks sintek for astonishing code but i would last thing after press command button whether add or subtract if is possible show the message gives me information the brand become value for instance the message is like this " theses brand 20w50 208l become 122 quantity and 20w50 12 X1l became 112 quantity so the message based on col c,e

hi, sintek i have found error type mismatch in the code if i fill data not match in what contain the sheet in this line

HTML Code: 

if there is way when not match data then show message box "not match" and exit sub " i appreciate that

what i fill in multiple combobox on userform it supposes the same what is existed in the sheet to add or subtract
for instance the data in sheet for specific brand is AA 20-W50 208L Q8 THI 124 but if i fill on user form differently like this
AA 20-W50 208L cas THI 5 as you see in col 3 not match as what existed in the sheet so the code can't run correctly because not match
i hope this help

yes ,add the data which not matched but it not show message after copy data to sheet

thanks sintek for every thing