Consulting

Results 1 to 2 of 2

Thread: ComboBox/ListBox Help

  1. #1

    ComboBox/ListBox Help

    I am teaching myself VBA and require some assistance.

    I have a combobox that brings up 15 or so different values. What I need to happen is the user clicks on a specific value from the combobox and then a listbox populates with a range of cells from another sheet.
    Basically it is like a search. EG: There are 10 package options to select from in the Combobox. By selecting one of the packages the listbox will populate with the description, cost, etc. of the package.

    Any help is greatly appreciated.

  2. #2
    VBAX Expert Tinbendr's Avatar
    Joined
    Jun 2005
    Location
    North Central Mississippi (The Pines)
    Posts
    993
    Location
    If I understand your description, what you're refering to is called a cascading combobox.

    In the combobox change event, you add the items to the listbox, either through Rowsource or Additem.

    If you provide a sample, I'm sure we can help you sort it out.

    David


Posting Permissions

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