Combobox options based on the input of another combobox

Hi Guys,

I have an excel spreadsheet where i have two comboboxes. However based on the input from 1 combobox i wish to have different options available in the second combobox. Is this at all possible in excel??

Any help would be greatly appreciated,

Aidan

Hi Aidan,

See xlDynamic's Dynamic Dependent Dropdowns page at:

http://www.xldynamic.com/source/xld.Dropdowns.html

Also, see Debra Dalgleish at:

http://www.contextures.com/xlDataVal02.html

and

http://www.contextures.com/xlDataVal13.html


---
Regards,
Norman



"afmullane" <[email protected]> wrote
in message news:[email protected]...
>
> Hi Guys,
>
> I have an excel spreadsheet where i have two comboboxes. However based
> on the input from 1 combobox i wish to have different options available
> in the second combobox. Is this at all possible in excel??
>
> Any help would be greatly appreciated,
>
> Aidan
>
>
> --
> afmullane
> ------------------------------------------------------------------------
> afmullane's Profile:
> http://www.excelforum.com/member.php...o&userid=33567
> View this thread: http://www.excelforum.com/showthread...hreadid=538416
>