View Single Post
  #1   Report Post  
JemyM
 
Posts: n/a
Default Point, Click and select from a menu/list...


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