>I appreciate all the suggestions and help the various users have offered
but I seem to conclude that it may not be
>possible for a combo box to function like a calendar control (i.e. quite
simply, for the user  to click on the down
> arrow and select  from the list). I am aware this can be done quite easily
in ACCESS by using the LimitToList >
>property of the combo box). If any one has a simple solution that works
exactly like the combo box in
>ACCESS, it would be welcomed.

Just a minute... Don't give up yet.

I believe that using "MatchRequired" in Excel is the same as the way an
ACCESS combo box works with "LimitToList".

> Even if you set match required = true, I found that in the
> combo box, you are still able to type  in a value that is not
> in the list.
> Yes admittedly it will throw up an error, but I would like
> the situation such that the user is only able to select from
> the list  and nothing else.

Using LimittoList in Access also allows you to type in entries not in the
list.

What *exactly* have you seen as a difference when you do what Moses???