jhone
10-05-2017, 07:05 AM
r/sir
i am create a user form in this excel sheet for add customer & supplier , if i am choose supplier in party type combo box the supplier/customer ID autogenrate Supp-001 ID,if i am choose Customer in party type combo box the supplier/customer ID autogenrate Cust-001 ID fill all the information, if i am choose Party type Combo box choose supplier & fill the information $ click on the add supplier command button all the information was save on the supplier excel sheet ,if i am choose Party type Combo box choose Customer & fill the information $ click on the add Customer command button all the information was save on the Customer excel sheet ,if you do not under stand please see attachments
thanking you
i am create a user form in this excel sheet for add customer & supplier , if i am choose supplier in party type combo box the supplier/customer ID autogenrate Supp-001 ID,if i am choose Customer in party type combo box the supplier/customer ID autogenrate Cust-001 ID fill all the information, if i am choose Party type Combo box choose supplier & fill the information $ click on the add supplier command button all the information was save on the supplier excel sheet ,if i am choose Party type Combo box choose Customer & fill the information $ click on the add Customer command button all the information was save on the Customer excel sheet ,if you do not under stand please see attachments
thanking you