Adding sub-menus and actions to data in drop down lists in Excel 2

I'd like to add functions to the user selected data in a drop down list, i.e,
if a user selects "Family Member" from a drop down list, I want another drop
down list or create new column with list (preferred) to generate so user can
enter relationship such as Father, Mother, etc. Any help would be
appreciated.

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"cchcc" <cchcc@discussions.microsoft.com> wrote in message
news:A428A3BB-175D-4D0E-8FA8-A79A7E3E1F16@microsoft.com...
> I'd like to add functions to the user selected data in a drop down list,
i.e,
> if a user selects "Family Member" from a drop down list, I want another
drop
> down list or create new column with list (preferred) to generate so user
can
> enter relationship such as Father, Mother, etc. Any help would be
> appreciated.