Dropdown box in a cell

[Man Utd]

How do I create a dropdown box in a cell ?

[mangesh_yadav]

One way:
Select cell, go to Data > Validation. select list and then the source for the list

Mangesh

[Bob Phillips]

You probably mean Data Validation. See
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Man Utd" <[email protected]> wrote in message
news:[email protected]...
> How do I create a dropdown box in a cell ?
>
>

[Man Utd]

This can be done at design time, because I may have 10, 20 or even 100 cells
need this drop down list, how do I do that programmatically when I click the
cell in a particular column, for example, from C10 to C100, if the user
click these cells, the dropdownlist will appear ?

"mangesh_yadav" <[email protected]>
wrote in message
news:[email protected]...
>
> One way:
> Select cell, go to Data > Validation. select list and then the source
> for the list
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
> View this thread: http://www.excelforum.com/showthread...hreadid=378908
>

[Bob Phillips]

Set up DV for all those cells.

--
HTH

Bob Phillips

"Man Utd" <[email protected]> wrote in message
news:[email protected]...
> This can be done at design time, because I may have 10, 20 or even 100
cells
> need this drop down list, how do I do that programmatically when I click
the
> cell in a particular column, for example, from C10 to C100, if the user
> click these cells, the dropdownlist will appear ?
>
> "mangesh_yadav"
<[email protected]>
> wrote in message
> news:[email protected]...
> >
> > One way:
> > Select cell, go to Data > Validation. select list and then the source
> > for the list
> >
> > Mangesh
> >
> >
> > --
> > mangesh_yadav
> > ------------------------------------------------------------------------
> > mangesh_yadav's Profile:
> http://www.excelforum.com/member.php...o&userid=10470
> > View this thread:
http://www.excelforum.com/showthread...hreadid=378908
> >
>
>

[Man Utd]

Thanks for your advice.
Now I have another question:
I have a data list in workshet 1 like the following:

Code Session Food Price
--------------------------------
001 Breakfast Milk $2
002 Breakfast Cereal $3
003 Breakfast Bread $1
004 Lunch Vegetable $3
005 Lunch Rice $5
006 Dinner Rice $6
007 Dinner Wine $10

What I need to do is in worksheet 2, I have 4 columns have the above
headers, when the user click the cell in Session column, I need to populate
a dropdown list of the Sessions (ie Breakfast, Lunch, Dinner).
Once the user selected the session, I need to populate the dropdown list in
the Food column for the Session.
After the Food has been selected, I need to fill in the Code and the Price
cells.

So the user select the Session, then the Food and I need to find the Code
and the Price.

How do I do the Food dropdown list fill in ?
And the search of the Code and Price for a particular food ?

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Set up DV for all those cells.
>
> --
> HTH
>
> Bob Phillips
>
> "Man Utd" <[email protected]> wrote in message
> news:[email protected]...
> > This can be done at design time, because I may have 10, 20 or even 100
> cells
> > need this drop down list, how do I do that programmatically when I click
> the
> > cell in a particular column, for example, from C10 to C100, if the user
> > click these cells, the dropdownlist will appear ?
> >
> > "mangesh_yadav"
> <[email protected]>
> > wrote in message
> > news:[email protected]...
> > >
> > > One way:
> > > Select cell, go to Data > Validation. select list and then the source
> > > for the list
> > >
> > > Mangesh
> > >
> > >
> > > --
> > > mangesh_yadav
> >
> ------------------------------------------------------------------------
> > > mangesh_yadav's Profile:
> > http://www.excelforum.com/member.php...o&userid=10470
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=378908
> > >
> >
> >
>
>