Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Cool Unanswered: import into combobox

    Morning all, or afternoon. I have a comumn of 800 names but only about 20 unique names, just spratically repeated. I need to make a combo box on a userfrom that will read those 20 names so I later send that name into a pivot table on the userform so it only shows the lines in the spreadsheet that have that persons name. Basically I am trying to make a userform that will tell each person all the different tasks they are responsible for when they select their name from the list in the combo box. And incase anyone asks, the names change frequently so I can't just type them in. Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Depending on how you want to do this, probably VBA code, you can use the Advanced Filter on the names, and choose to show only unique names, and place it in another column, and give it a dynamic named range. Then, in code you could refer to the dynamic named range and supply that data to the UserForm.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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