add & subtract values from userform to specific column in sheet

[ABDELFATTA]

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

[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.

[ABDELFATTA]

hi, 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

[torachan]

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.

[sintek]

For add userform use below...For subtract userform use same but change red + to -

Please Login or Register  to view this content.

[ABDELFATTA]

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

[sintek]

so the message based on col c,e

Col B,E you mean...


Add this snippet...

Please Login or Register  to view this content.

After

Please Login or Register  to view this content.

[ABDELFATTA]

thanks sintek for all theses codes and your correcting about clo b , e not c, e you solved my two threads today
god bless you

[sintek]

All good.....

[ABDELFATTA]

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

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

[sintek]

My bad...x must be Chk

Please Login or Register  to view this content.

[ABDELFATTA]

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

[sintek]

See Edited Post 11

[ABDELFATTA]

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

[sintek]

Not gonna spoon feed you anymore...Add MsgBox code snippet where you want it...

[ABDELFATTA]

thanks sintek for every thing