Userform, Worksheet, change work code

[Sonderto]

Hi, I have code that currently work great, It will all data about Order place in the Orders worksheet and Stock placed into the Stock worksheet, and when the Product, Customer and order has been select it places the required data for the order and what stock has been selected into the despatched worksheet. However I am try to modify it so that it will also place the Order No for Customer from listbox1 column 2 and then place it against all the selected stock from listbox2. So it will have to find the stock on the stock worksheet looking at the Product column B and then the Batch no column C and then the pallet no column D and then it find a match place the order No into Column E.

To use the workbook Open it, the workbook should open the dedpathed worksheet, the workbook has three worksheet one for Orders, Stock and the above mentioned Despatched worksheet (Yes I know I spelt it wrong, in a rush). So go to the despatched page click the button and show the user form, Select from the 1st combobox Product 1 and then from the Second Combobox Customer 10, then from the third the Order No. This will display data from the worksheet into Listbox 1 and Listbox 2. listbox hold data about the order and Listbox2 hold the stock data. Now select one from the listbox1 and 1 or more from Listbox2 and then click on the Add Order Button to enter it.

I've placed the Code that I using at the moment that That I need to be modified.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

See attached

[Sonderto]

Thanks Richard, I didn't think of that as I was looking for a vba option, this works great.