Results 1 to 18 of 18

Populate Values in Multiple List Boxes based on Multiple Criterias

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-19-2012
    Location
    Woodbridge, Virginia
    MS-Off Ver
    Excel 2010
    Posts
    111

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 05-19-2015, 11:53 PM
  2. Populate cells on multiple sheets based on list
    By jhammond10 in forum Excel General
    Replies: 4
    Last Post: 06-30-2013, 04:16 PM
  3. Macros to update cell values based on multiple criterias
    By ccernat in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-22-2012, 03:25 AM
  4. Replies: 4
    Last Post: 01-31-2012, 04:36 AM
  5. Replies: 5
    Last Post: 07-21-2008, 07:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1