I have created subject system in excel, I want to make it automated through userform. Since one week I m working very hard, now my head is aching of thinking of the repeated errors.
I need your help very badly.
My Requirement in attached sheets are:
1. ProductCode Combo Box drop down Value must be from the sheet "Master Inventory" Column "B" excluding header till the last row.
2. As I will be able to select Product Code, its available quantity which is in Column "N" in the same sheet, must shown in AvlbleQnty Label Box.
3. QntyTextBox must accept only the quantity lesser than the available quantity which is AvlbleQnty Label Box.
4. Whichever ProductCode's Available Quantity is less than 5, I need a Command Prompt "Would you like to order this Product Now or Later", If Ans is Yes, it must pop up another User Form "OrderForm", where I can input Date(CalenderFrm popup), Product Code, Supplier Code, Description, Size & Qnty. (I haven't created such UserForm yet in attached sheet). After Clicking Add button, it must update in the last row in OrderForm Sheet.
5. Discount Combo Box must be drop down only for the "Supplier", which I may select from TermComboBox.
Please help....Thanking you in Advance.