Using For Function

Hello,

I´m trying to build an inventory form where once i click a capture button, it subtracts or adds to an inventory table. Im having trouble figuring out how to use the for function.. here`s the code and a brief explanation of where i know i`m failing but having figured out. Please pardon my writing if it sucks, I`m mexican.

Here is what i pretend to achieve with this button
1) subtract or add to an inventory list, depending if im receiving a product or releasing one..
Therefore i have ,per say ,4 comboboxes with the product listing to pick, and 4 other comboboxes on the side to select the quantity of each product i select. The first problem arises when I only select one product, the 2nd combobox product list is left empty. As you will see in my code, im always looking for the combobox list in a list i have in my worksheet and then subtracting or adding depending the case. When my code is running and i only pick 1 product rather than 2,3,4 or 5 possibilites i have on my userbox, i get an error because it tries to make an operation with no values.. I hope I explained myself ok.. Im very new with VB so sorry if i suck.

2)The 2nd part of my code tries to carry this history to another worksheet. ( was working fine but now it`s not

3)next I want to clear the user form but ,I`m not getting that, I was yesterday but don`t know what happened.

4) I`m also trying to carry the history to 2 different sheets by using a multipage in my userform. one page for arriving parts , and another for leaving parts.. any advice on how to do this?


Here`s the code.

Please Login or Register  to view this content.

This is difficult without the userform and workbook

Try this

Please Login or Register  to view this content.

If this works, we can thin it out a bit more later
Hope this helps

The idea of Code tags is to make the code stand out & help us copy it, colouring it blue defeats the object!makes it useless to copy to the VB Editor

Use the forum facilities to attach a file.

FAQs
How do I attach a file to a post?

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

Im also getting an error on this line, when i fill up more than 1 article.

Please Login or Register  to view this content.

Right,last warning about code tags