fixitsteve
New Member
- Joined
- Dec 31, 2005
- Messages
- 3
I have a database in the form of a table on one worksheet. Each field within a record may be repeated multiple times as shown below:
Name1| Size1 | Color1_for_Size1 | subAttribute_forColor1_for_Size1
Name1| Size1 | Color2_for_Size1 | subAttribute_forColor2_for_Size1
Name1| Size2 | Color1_for_Size2 | subAttribute_forColor1_for_Size2
Name2| Size1 | Color1_for_Size1 | etc.
Name3| Size1 | Color1_for_Size3 | etc.
I'd like to programmatically populate Listbox1 (on another worksheet from the original data) with the unique members of the Name field. Dependent on the value chosen in Listbox1, I'd then like to populate Listbox2 with the unique values in the Size field for that value. And so on for multiple (say up to 5) fields. Would the application run faster if the searching for the listboxes was done once and then stored?
I'd appreciate as much help as anyone can give!!
Name1| Size1 | Color1_for_Size1 | subAttribute_forColor1_for_Size1
Name1| Size1 | Color2_for_Size1 | subAttribute_forColor2_for_Size1
Name1| Size2 | Color1_for_Size2 | subAttribute_forColor1_for_Size2
Name2| Size1 | Color1_for_Size1 | etc.
Name3| Size1 | Color1_for_Size3 | etc.
I'd like to programmatically populate Listbox1 (on another worksheet from the original data) with the unique members of the Name field. Dependent on the value chosen in Listbox1, I'd then like to populate Listbox2 with the unique values in the Size field for that value. And so on for multiple (say up to 5) fields. Would the application run faster if the searching for the listboxes was done once and then stored?
I'd appreciate as much help as anyone can give!!