You received an answer to this from Debra Dalglesih yesterday.

See her answer at this google search result.

http://tinyurl.com/26o2tf



Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 07:58:06 -0700, Oct1196
wrote:

I need ot create a dependent list where a user can select multiple options
from the dependent list. example, when a state is selected, the dependent
list displays teh corresponding county list for the state selected. Ithe
users needs to select, one, all or multiple counties fromt eh dependent list