Dependent dropdown list in use form

Hi,
I want to create dependent drop down list in user form in vba. Second drop down will show text as per the choice of first dropdown. 1st and 2nd dropdown list text will be taken from specific cells from sheets 1 for me it is database sheet. For example if i select fruits in 1st dropdown list then in 2nd dropdown there will be Grapes, Apple, Banana, but if select vegetables in 1st dropdown then there will be options ladyfinger, tomato, coli flower in 2nd dropdown.
Also when i want two buttons like, Add and close. Add button will add the data in blank rows but will not close the form. New data will be added to next blank row. When i will click on close button, it will close data entry form.

Thank you

Originally Posted by chintamani.avinash

... if ... vegetables in 1st dropdown then there will be options
ladyfinger ...coli flower in 2nd dropdown ...

Saints of Lord ! Holy Aubergine, Holy Biscuits and you Holy Microbes !

... ladyfinger and E. coli = vegetables ...



Attach a sample file with what you have already achieved, i.e. userform, vbe.
Change confidential data to false data to protect privacy and "company secrets".

Table 1 - Sheet2 - feed for comboboxes.
select combo1 followed by combo2 on press 'ADD' places on Sheet1 Table2
torachan.

Originally Posted by torachan

Table 1 - Sheet2 - feed for comboboxes.
select combo1 followed by combo2 on press 'ADD' places on Sheet1 Table2
torachan.

Thanks for reply. I am here attached my file for more understanding. I want to have both text entries i.e. 1st category and dependent entry in blank row. Also user form will adjust dependent list as per the given data in sheet 2. Means if i add new mail category or sub category then user form will adjust that also.

Sorry, I do not fully understand what you want.
Therefore rather than add to confusion I will leave it up to someone else to fulfill your requirement
torachan.