PDA

View Full Version : ComboBox/ListBox Help



gordo7787
03-06-2011, 11:53 PM
:banghead: 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.

Tinbendr
03-07-2011, 06:19 AM
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.