listbox help

[chicken9]

based on these images (the bottom table): http://oi40.tinypic.com/2n0ijw9.jpg
this question:

The form should provide a list box containing a list of all the possible products to be purchased, from which the user may select one particular rose variety(**ive done this so far:

Please Login or Register  to view this content.

Once the variety is selected, user should be able to select the category of the plant from a second list, which shows only the available categories of the selected rose variety(** look at this http://oi42.tinypic.com/jj8gmv.jpg). If a certain category is not produced for the selected variety such categories should not be available for selection (eg. Royal Bassino should display only ‘ground cover’ and ‘standard’). Note that the user also needs to specify the quantity of each rose plant. The user should not be allowed to order more than the quantity available.

Moderators note: code tags added for you - this time

[FDibbins]

Hi and welcome to the forum chicken

Sorry to give you a hard time with your 1st 2 posts

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I will add them for you this time, please remember to use them in future

Also...
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)