+ Reply to Thread
Results 1 to 2 of 2

Listbox linked to Combobox

  1. #1
    Registered User
    Join Date
    03-13-2005
    Posts
    29

    Listbox linked to Combobox

    I have a spreadsheet that I have designed to help me track incoming invoices so that I don't pay the same one twice if it gets sent in again. It runs off a list that includes the vendors name, the invoice number, amount and so on. The invoice numbers are unique, but obviously each vendor is in there multiple times.

    I have created a VBA interface page. A combobox on this page has the vendor list as it's source. I have a listbox that I need to link to it in such a way that when I select a specific vendor, the listbox populates with the invoice numbers from that vendor and that vendor only.

    Any ideas on how to do this?

    Thanks,
    Scott

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    VendorInvoice

    Scott,

    See if you can use this. If you can it can be modified for data input.
    Note: Need to trap error which this attachment does not.
    Last edited by Charles; 01-24-2007 at 12:56 PM.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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