abdo meghari
Active Member
- Joined
- Aug 3, 2021
- Messages
- 465
- Office Version
- 2019
hello
I have amany multiple comboboxes linked with COLUMN B,C,D,E and textboxes link with column F about the QTY for textboxes start from 6 to 10 is for the ITEM start from 1 to 5
so what I want when select combobox category should automatically fill the others , and I write values in textboxes (QTY) manually if less than or equal what are existed in sheet1 in COL F and press command button then should copy to sheet2 from row4 and if they are bigger than what are existed in sheet1 in col F then should show message contain detailes the QTY for the items and doesn't copy to sheet2 like this
"this is bigger than what available please choose less"
item QTY
1 10
2 30
attached some pictures
step1
step2 should fill automatically
step3 write values manually in textboxes(QTY)
should compare with COL B,C,D,E,F and pop up message if the values are bigger and not copy to sheet2 in this case
and if less or equal then should copy to sheet2
thanks in advance
I have amany multiple comboboxes linked with COLUMN B,C,D,E and textboxes link with column F about the QTY for textboxes start from 6 to 10 is for the ITEM start from 1 to 5
so what I want when select combobox category should automatically fill the others , and I write values in textboxes (QTY) manually if less than or equal what are existed in sheet1 in COL F and press command button then should copy to sheet2 from row4 and if they are bigger than what are existed in sheet1 in col F then should show message contain detailes the QTY for the items and doesn't copy to sheet2 like this
"this is bigger than what available please choose less"
item QTY
1 10
2 30
attached some pictures
step1
step2 should fill automatically
step3 write values manually in textboxes(QTY)
should compare with COL B,C,D,E,F and pop up message if the values are bigger and not copy to sheet2 in this case
and if less or equal then should copy to sheet2
thanks in advance