Drop-Down list in a cell

[Werner]

Hi,

I have cells in an Excel form which are used to enter data. But it's always same list of choices. I wonder if there is a way to create a drop-down list of choice in a cell, so that the user can choose between the available choices. Is it possible?

Thx!

Werner

[olasa]

Yes, it called Data Validation list.
Here's how to create the list: http://www.contextures.com/xlDataVal01.html

HTH
Ola Sandström

[Werner]

Thank you olasa for your help!

Regards,

Werner

[Max]

Try Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal13.html
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Werner" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I have cells in an Excel form which are used to enter data. But it's
> always same list of choices. I wonder if there is a way to create a
> drop-down list of choice in a cell, so that the user can choose between
> the available choices. Is it possible?
>
> Thx!
>
> Werner
>
>
> --
> Werner
> ------------------------------------------------------------------------
> Werner's Profile:
http://www.excelforum.com/member.php...o&userid=24304
> View this thread: http://www.excelforum.com/showthread...hreadid=390536
>

[Max]

Try also this page of Debra's:
http://www.contextures.com/xlDataVal02.html
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

[olasa]

Happy it helped
Thanks for the feedback
Ola