+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Populate Userform Combobox from Pivot Table

  1. #1
    Registered User
    Join Date
    10-02-2011
    Location
    Stratford, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Populate Userform Combobox from Pivot Table

    I am stuck on trying to get my user form to populate my combobox from a pivot table that I am using. In this userform you are to pick from customer numbers (this is the combobox) that are in this pivot table and then from there pull the rest of there info (i.e slip#, dry tu) into a listbox where they can check which items will go into another sheet. If someone could shed some light on this that would be just perfect. I have attached a sample and if more info is needed I would be happy to provide it.

    I thank you in advance for your help.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-02-2011
    Location
    Stratford, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Populate Userform Combobox from Pivot Table

    Hi again,

    Maybe my question was not clear enough so I will try to break it down. In the userform would like to be able to pick a customer number from the combobox and from that it will populate the slip information in the listbox from a pivot table that I can check multiple slips that would be sent to an invoice. Could this be done or should I just populate the userform with info from an excel table?

    Andrea

+ 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