+ Reply to Thread
Results 1 to 2 of 2

ListBox or ComboBox - which to use??

  1. #1
    Forum Contributor
    Join Date
    03-14-2005
    Posts
    164

    ListBox or ComboBox - which to use??

    Hi all,

    I want a drop down list on the first sheet of my workbook.
    this should be populated with a list of vlaues in column A of another sheet (results of a query, so could increase in numbers)

    I'm not sure whether to use a listbox or combobox.
    (not sure of when to use one or when to use another)

    I will be passing the value of this drop down into a query written in VBA.

    can anybody advise.
    possibily with the code that would be required to select a dynamic range in columnA of the other worksheet..

    thanks in advance,

    Matt

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Add Item to combo box

    Check out this thread for an example of adding items to ComboBox


    http://www.excelforum.com/showthread...45#post1715845

+ 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