Results 1 to 8 of 8

ComboBox - VBA - Unique Views...

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2009
    Location
    Honiton, England
    MS-Off Ver
    Excel 2003
    Posts
    7

    ComboBox - VBA - Unique Views...

    Hi Guys,

    I've been struggling with this for a while, I've used an advanced filter upuntil now but it's not working.

    I have a column that is updated several times a day, I need to be able to view that list in a userform combo box and that box to be able to react like an autofilter list. I've tried the advanced filter thing but as th elist is contantly updated it makes this very hard to handle as I have to set macros to compile the list and then delete it once it's been used. Is there a way I can set vba code so the ComboBox populates unique fields, sorted AZ and removed the blanks without using the advanced filter..??

    I've been researching this for ages and can't find a solution... Please help.



    Regards

    Jason
    Last edited by Strat94; 07-15-2009 at 09:18 AM. Reason: Solved

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