Results 1 to 20 of 27

Thread: Solved: Populate a comboxbox and Listbox in a excel userform with an sql table data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-14-2010, 01:25 PM #6
    abhay_547
    abhay_547 is offline
    VBAX Contributor
    Joined
    Sep 2009
    Posts
    130
    Location

    Excel Combo box to be filled with sql table column data

    Hi All,

    I want to populate my excel userform combo box with one of the sql database table column unique values. I am using the following sql statement in my code but it shows me all values present in the sql table column for e.g. I can see America region name 4 times in the drop down I want that the combo box should show it only once. Following is the sql statement used by me in my macro code :

    stSQL = "SELECT Region FROM [Region_Mapping]"

    Please expedite. Thanks for your help in advance.
    Last edited by Aussiebear; 04-19-2023 at 02:04 PM. Reason: Adjusted the code tags
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules