programming userform buttons and text boxes and drop down.

I am working on a userform to enter data where each data type may not have any units to input. What I would like to do is type in the invoice number. If it exists it will show the data for that invoice number. It will also show the first filled prime key with a number greater than 0. When I click next it will go to the next prime key with a value greater than 0, not the next row. If the index number isn't in the form, it will ask if I would like to create a new invoice. No closes the question and nothing changes. Yes adds that invoice # to the next blank line in the table and I have the ability to choose the prime key and enter a quantity for that prime key. Then click add. Adding does not add a new line, only a new quantity to the prime key currently selected. If there is a quantity already in that prime key I would like a pop up to ask if I'm sure I want to overwrite the current quantity. Close Closes the form and saves the worksheet. Oh and the description shows whatever prime key is chosen so prime key 2 would show the contents of C3 and prime key 3 would show D3 etc. I have no clue how to do any of this so even one bit at a time would be great. I attached what I have so far and included these instructions in the userform to simplify it for anyone helping. Thanks So much!

There is code in there when I was trying to do something else but I may have to scrap it and start over with a lot of it.

Maybe this will help... Type invoice number into TxtInv. Press Enter ->Search column A for that number.
If found Return the row number to "r" Fill TxtInv with Column A row r and fill CmbPrime with the first nonzero number found on row r between columns B through G. Fill TxtQty with the number found on the column with the non zero number. Fill TxtSubtotal with the result of multiplying the number filled in TxtQty by That same column row 5. Fill TxtTotal with the total of all the numbers in the row multiplied by the related column row 5 to get the total for the invoice. Clicking next will go to the next nonzero number on row r.

If not found -> message "Not found, would you like to create one?" If no, wait for user to input different data. If yes, Add to the first blank line the number typed into TxtInv. Then the user would select a number from CmbPrime to choose which to add. User inputs quantity into TxtQty and clicks ADD. When Add is clicked That qty is added to that invoice number row with that prime key column and saves the worksheet. If the user chooses another number from CmbPrime He can click add and add that to row r. Once user is done entering data he can click close to close the userform. User may also type in a different number into TxtInv to start over.

That is essentially what I have. The only difference is an added short description for the type of unit which I don't need. As far as using text boxes to store quantities and numbering text boxes according to the columns and labeling my descriptions gives me a huge form. I am trying to keep the form small and not have all 1200 text boxes listed. This is why I was wanting to code the combo box to select which column to enter the data.

Your form had an error when I tried to run it. And I could use a txt box instead of a combo box, but my point is I can't have 1200 text boxes. I need one that is populated with the data and click next to go through any nonzero numbers. Instead of choosing one in a combo box, I could type which unit in a text box, but the rest of the coding would still need to be the same.

That's much more like what I am looking for, thanks. Now to just get it working! I need to be able to add to a new blank line and this seems to only overwrite, also when selecting an invoice, I need to be able to edit it through the form. Also the filter doesn't seem to work and I need the prime key label on there on the table it loads, preferably at the beginning rather than the end. Thanks. I'll play with what you have given me and see if I can figure it out.

If I save without adding an invoice number then it doesn't allow me to control the invoice number. I need to be able to write in the invoice number as this is one of several jobs. For instance Job1 may have invoices 1-3 Job2 may have 4 & 5 and Job 3 may have 6-9 then Job 1 may have 10-14. I need one of these sheets in each job folder, but the invoices must be manually input as part of the data.

And I realize I can type the invoice in after saving and then save again to change it, but that seems like a waste of a step that can cause errors that should be easily fixable with code. Whenever you click save it checks if the invoice exists. (This is standard coding practice for error checking) if it does exist I have the option to overwrite, if it doesn't then I can create a new one.

Also the load button is getting an error when I create an invoice that way. It loads the rest, but not the newly created one.

And when I add a unit, if I don't add one to the I column, it is #N/A

Bumpzzzzzzzzz...

Made a few modifications, but I'm still not able to input prime key 9 and when I save a new invoice row of data, prime key 9 gets #N/A in the row.

Private Sub CommandButton3_Click() is where the problem is.

Bumppppppp

Nobody is responding to my post. I'm wondering if I should just find another forum...