That will require multiple cells. One cell will only hold 1 value. Any single
cell solutions are going to be more complicated than it is worth.
--
HTH...

Jim Thomlinson


"acf33" wrote:

I am trying in vain to create a drop down list where users can select more
than 1 choice. For example, if the choices in a list which i named are as
follows:

Blue
Red
Green
Yellow
Purple

How does one have the option to select any of the colors by themselves or
any combination of all of them up? For example, if the question is what is
your favorite color? How can a user choose Blue OR Red and Blue OR Red, Blue
and Green and so on?

Any help would be appreciated.