I'm trying to make an order form in Excel with a userform, multipages, frames, labels en textboxes.
My workbook contains different worksheets: Customers, Products, Fixed orders, etc
There is one dropdownbox for selecting the right customer. Once selected, you see more detail about the customer (all data are fictional).
I'm am searching for a way to do following:
There is a sheet called "Vaste bestelling" (Fixed orders).
On that sheet, there is a column with the different customers and all the products.
If there is a "y" then this product is ordered regularly. If there is a "n", this product is not relevant for that customer.
You select a customer (detail customer is shown) and now the products labels in the frame should show only the products that are regularly ordered by that customer.
I'm trying but I'm not getting there.
Who can help me?
Thx in advance
PS: sorry for my bad English