I've edited the code for PickForm so that when a product type is selected then that range of products is loaded to the ListBox
Ty
I've edited the code for PickForm so that when a product type is selected then that range of products is loaded to the ListBox
Ty
I'm trying to understand what the form does and have made some more changes. I'll post an update later.
Check this. The users selected items are entered to the second Listbox and the amount calculated. This can then be posted to the Order Sheet.
I have amended the order sheet slightly to make the code more efficient.
Check this. The users selected items are entered to the second Listbox and the amount calculated. This can then be posted to the Order Sheet.
I have amended the order sheet slightly to make the code more efficient.
Hi Roy, again thanks for your help but it seems we have gone right of track, not to sure there's now a customer pull down which i don't need unless your just trying to show me how to do stuff.
nothing else seems to work now either
What doesn't work. I was trying to guess what you wanted to do with the userform.
Somewhere we lost our way, This is the current forms im using there are a few little niggles that i need to get sorted but the main thing i cant work out is when using the pickform i add an item with an amout which is FROM STOCK i want it to deduct the amount from the sheet to i keep my stock levels corrects.
The last sheet gave you was cut down quite a bit as you suggested that because i have so many sheets it was going to make it hard to do this and we have seemed to have gone right of track from there.
Im hoping im a bit more clear =??
You agreed that the workbook needed re-designing. The PickForm wasn't working so I have checked all the coding. The ComboBox allows you to pick a Category and display it in the second ListBox. When the pick is completed the selection is written to the Order,
Good Morning Roy,
Correct on the sheet i last uploaded this all works fine with just a few little issue's that will need sorting ie. showing zero's on the print out etc but this is not stopping me from creating a form and getting my ironmongery ordered.
I don't know which form you are talking about. I haven't looked at the stock control yet because I thought the PickForm was what you needed first.
Dont worry about it Roy thank you for all your help.
Odd response. I've just checked the unaltered Revamp workbook and PickForm does not work.
Anyway good luck because I won't waste time in future.
Don’t have an account yet? Register yourself now and be a part of our community!