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
Bookmarks