I'm sure there's a better way but here's one way.

Say that your check box is linked to A1 and your drop down menu is in
B1, then select B1 go to Data/Validation, select "list" from the
"Allow" menu and in the formula box type something like:

=IF(A1=TRUE,list1,list2)

list1 would be your drop down menu data, list2 would be any empty cell,
when the check box is checkcked then the drop down menu will show list1,
unchecked then list2 (empty).

For the "Other" option cell you could also use Data
Validation....select "custom" from the "allow" meu and type:

=B1="other"

data will only be possible if B1 = "Other", I would also use
conditional formatting to make the cell invisible unless "other" is
selected.

Hope this helps!
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=510527