linked listboxes

[tanner]

Hi,

I'm not very familiar with Access and I'm trying to develop an
application in Excel without having to resort to a database program.

I want to be able to have a userform where a user selects a supplier.
Based on that selection, a user then can select a product catagory.
Based on that choice they can choose a product and, finally, the
product choice would bring up a listbox or dropdown box with available
colors.

Am I doing this right? Should I be thinking of another way to get the
information without using listboxes? If I had part numbers, could I
then just call up everything from that?

Any help would be greatly appreciated. I just don't want to spend
hours trying to develop something that won't work.

Thanks,

Tanner

 

[JLGWhiz]

Vendor>Type Product>Product>Variety Detail makes sense to me. The only
concern I would have would be pyramiding effect as the type product and then
the specific products are developed. I suppose to reduce the number of list
boxes, you could use one UserForm with a ListBox for the Vendors, then on the
same UserForm, use labels to populate with the Vendor product types. Once
the user selects a label with the product type then a second UserForm with a
listbox for the
product variety of that type, with labes or a text box to give details for
each variety.
That way you would just be calling the data from your worksheets where all
the infor is stored as it is needed for the labels and text boxes rather than
trying to put everything in ListBoxes . Just a thought. I'm sure there are
other methods.