Populate Values in Multiple List Boxes based on Multiple Criterias

All,

I am completely stuck and don't know where to even begin. I've attached my workbook to this post.

Background of Workbook:
InvoicingForm Worksheet is used to pay off invoices.
InvoiceDatabase stores Invoice Information.
PaymentDatabase stores payment information.

Two buttons:
Add Invoice - Userform to enter invoices.
Outstanding Invoices - Userform to show outstanding invoices.

FYI - Need invoices before payments can be made. "Add Invoice" button is used to add the invoices. Then use the InvoicingForm to make payments to the outstanding invoices.

Issue is the Oustanding Invoices Userform:
I am trying to populate the first listbox with all of the oustanding "Customer Name" values based on the Company Name field (companyNameInput) from the Outstanding Invoices userform. To determine the oustanding invoices, it would look in the InvoiceDatabase and the PaymentDatabase to determine which invoices have balances. Then, after clicking a Customer Name from the list box, populate only the outstanding Invoice Numbers which are dependent on the Customer Name/Company Name. After that, populate the outstanding categories which are dependent on the Invoice Numbers/Customer Name/Company Name. Can anyone please help with this request?

Thank you in advance!

J

I'm taking a look at it, I recently made something similar!

Awesome! Thank you! Will be looking forward to your help!

I got it working, but i am a little confused about the category section. Do you play on having multiple payment lines for the same invoice?

Ok scratch that, I got that now. Do you plan on having multiple categorys on the same invoice?

Here is what I have so far. I just need a little more clarification on the purpose of the category box. Will there be more than one category per invoice?

Thank you again for your help.

There can be multiple payments for one invoice. There will be just one category per invoice.

There can be multiple customers though per company. We deal with one company but multiple representatives within the company and each of them can have multiple invoices open at one given time.

I hope this makes sense.

Thank you again for your help!

I think you are on the right track though! Just noticed though that the company names come up in the customer name list box. I was hoping for the customer names to populate based on the companyNameInput value.

Sorry to make this even worse. But will only the outstanding invoices appear? For example, if the full payment was made for INV001, this will not appear in the Oustanding Invoices Userform. However, if a partial payment was made, the invoice will appear in the Oustanding Invoices Userform.

Please let me know if this can be done. I have no clue if this can be done and how it can be done..

Thank you.

Oh so you need a drop down by the company name?

I didn't think about that. I guess it would be better with a drop down menu for the company name.

what i was asking about the categories is , will there ever bee more than one in the list box? LIke two lines for the same invoice, but different categories?

Yes, there will be more than one category in the list box. I just checked and there are instances where there are two lines for the same invoice with different categories.

Ok, i have school tonight so I may not be able to get anything until tomorrow.

Works for me! Thank you again for your help!

I would greatly appreciate it if you can provide any thoughts on this.

Thank you so much for taking your time to help me with this. It looks great!!! Thank you again!!

No problem glad I could help.