Point, Click and select from a menu/list...

**JemyM** · 09-11-2005, 09:52 AM

I am fine with just pointers where to start to look and learn how to do this.

In some excel documents I downloaded I have seen point-n-click drop-down-menues. It can be such simple as:

[ Yes/No ] <- Click, then select options from the list that falls down.
[Yes____] (returns TRUE)
[No_____] (returns FALSE)

Or
[Select your fruit] <- Click, then select options from the list that falls down.
[Orange_______] (returns value = 1)
[Apple________] (returns value = 2)
[Pinapple______] (returns value = 45)

If someone can just tell me what this function is called I will be able to use the web for more info how to do it.

Help anyone?

Max · 09-11-2005, 11:05 AM

Perhaps try Debra's nice coverage on data validation?
Start at her: http://www.contextures.com/xlDataVal01.html
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"JemyM" <JemyM.1v76uf_1126447544.5646@excelforum-nospam.com> wrote in
message news:JemyM.1v76uf_1126447544.5646@excelforum-nospam.com...
>
> I am fine with just pointers where to start to look and learn how to do
> this.
>
> In some excel documents I downloaded I have seen point-n-click
> drop-down-menues. It can be such simple as:
>
> [___Yes/No____ ] <- Click, then select options from the list that falls
> down.
> [Yes____] (returns TRUE)
> [No_____] (returns FALSE)
>
> Or
> _[Select_your_fruit]_ <- Click, then select options from the list that
> falls down.
> [Orange_______] (returns value = 1)
> [Apple________] (returns value = 2)
> [Pinapple______] (returns value = 45)
>
> If someone can just tell me what this function is called I will be able
> to use the web for more info how to do it.
>
> Help anyone?
>
>
> --
> JemyM
> ------------------------------------------------------------------------
> JemyM's Profile:
http://www.excelforum.com/member.php...o&userid=26945
> View this thread: http://www.excelforum.com/showthread...hreadid=466610
>