Dependent Combobox in Excel Userform

**2Deep** · 12-06-2010, 09:11 PM

Hi,
I am very new to excel VBA programming, and I am trying to create userform with Comboboxes.
Here is what I have so far,

userform named (EXPENSE)
Combobox1 (CboECategory)
Combobox2 (CBoESubCategory)
Commandbutton 1 (CmdSave)
Commandbutton 2 (CmdClose)

I also have Named Lists for "Exp_Category_List" and "Exp_Subcategory_List" in Sheet named LookupLists

Below is the code to populate the comboboxes:

Please Login or Register  to view this content.

I can get the "CboECategory" combobox to populate with the given list. But I cannot get the "CboESubcategory" combobox to populate depending upon the value in first combobox. As seen above, the commented code I used doesn't list the required values.
Any help would be greatly appreciated.

Thanks
2Deep

**davesexcel** · 12-06-2010, 09:23 PM

You have not supplied a sample workbook.
You need to populate the 2nd combobox when you change to 1st combobox
Check out this thread for an example

http://www.excelforum.com/excel-prog...x-vb-help.html

**2Deep** · 12-07-2010, 01:12 AM

thanks davesexcel,

attached is my sample workbook. I tried your sample. Its working, but have little problem. When I select category "CASH/CREDIT ACCOUNT" it lists correct sub-categories..... but if i change and select different category for eg. "DAILY HOUSEHOLD" it does not update the list.

In a sense the sub-categories are not refreshed when i select different categories. How do i get around it. Thanks again for your reply.

2Deep

**davesexcel** · 12-07-2010, 01:49 AM

Try This

Please Login or Register  to view this content.

**2Deep** · 12-07-2010, 08:54 AM

its working thanks a lot man.... how do i save this thread as solved ..

**davesexcel** · 12-07-2010, 08:59 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save