VBA for Dependent Combo Boxes

Hi

Can anyone help me in providing a VBA code for implementing Dependent Combo boxes for instance for Country -> State -> City cascading comboboxes in a User Form

The country ,state,city values can be read from a worksheet.



-Ansar

Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

Is there any other way. i found that a lil too over complicated

Yeah, do it in Excel without VBA.

Originally Posted by Bob Phillips

Yeah, do it in Excel without VBA.

I am having a Userform with 4 combo boxes , is there any way with excel to accomplish the same .

Thanks !

I gave you some code, if it is too complex for you I suggest that you revisit what you are trying to do, or pay someone to do it for you.