Hey all,
I am trying to quickly get order data from a single sheet of over 3000 entries using a UserForm to make it as simple as possible for staff. So far i've made a userform that i want to use containing a number of text boxes: "Cust ID", "Order #", "Item", "Part No", "Date Ordered", "Status"
I currently have the userform set so that as i type the Customer ID into into ComboBox1, my ComboBox2 auto-updates with all the order numbers associated to that customer ID. On selecting the required order number in ComboBox2 and pressing a command button, i would like the a number of TextBoxes on the UserForm to populate based on the selections made in the two comboboxes.
For example,
<tbody>
</tbody>
ComboBox1 = Smith999
ComboBox2 = ZQ456
would fill the following textboxes:
Item: Hook
Part No: 14557
Order Date: 21-4-19
Status: Del. Due
As you can see, there may be multiple orders of the same/similar parts for each customer, so that is why i am using the CustomerID & Order Number to quickly find the order status. So far i've been looking around and have seen a few VBA VLOOKUP examples, but these only work with a single criteria.
Can anyone assist with some VBA that might help use multiple criteria to fill my text boxes please??
I am trying to quickly get order data from a single sheet of over 3000 entries using a UserForm to make it as simple as possible for staff. So far i've made a userform that i want to use containing a number of text boxes: "Cust ID", "Order #", "Item", "Part No", "Date Ordered", "Status"
I currently have the userform set so that as i type the Customer ID into into ComboBox1, my ComboBox2 auto-updates with all the order numbers associated to that customer ID. On selecting the required order number in ComboBox2 and pressing a command button, i would like the a number of TextBoxes on the UserForm to populate based on the selections made in the two comboboxes.
For example,
CustId | Order Number | Item | Part No | Date Ordered | Status | Expect Del | Multi-part Order |
Franks123 | AB123 | FLANGE | 123456 | 12-7-19 | IN ORDER | N/K | Y |
Smith999 | ZQ456 | HOOK | 14557 | 21-4-19 | DEL DUE | FRIDAY | Y |
Jones145 | HP445 | KNOB | 457544 | 23-2-19 | AWAIT BUY | N/K | N |
Smith999 | CU124 | SCREW | 4564744 | 18-4-19 | AWAIT BUY | N/K | N |
Smith999 | ZQ124 | HOOK | 47735 | 17-8-19 | DEL DUE | FRIDAY | Y |
Franks123 | HP687 | SCREW | 36697 | 12-6-19 | AWAIT BUY | N/K | N |
Jones145 | AB124 | FIXING | 368759 | 30-3-19 | IN ORDER | N/K | N |
Smith999 | ZQ554 | HOOK | 68857 | 19-2-19 | IN ORDER | N/K | N |
<tbody>
</tbody>
ComboBox1 = Smith999
ComboBox2 = ZQ456
would fill the following textboxes:
Item: Hook
Part No: 14557
Order Date: 21-4-19
Status: Del. Due
As you can see, there may be multiple orders of the same/similar parts for each customer, so that is why i am using the CustomerID & Order Number to quickly find the order status. So far i've been looking around and have seen a few VBA VLOOKUP examples, but these only work with a single criteria.
Can anyone assist with some VBA that might help use multiple criteria to fill my text boxes please??