Thread: Pick List Box

How do you set up a pick box in a cell.

What I want to do is when you go to cell, let say G4 I would like to open a
pick box or list that would have names in it to pick from. And, can I edit
the contents of the box.

would this be a programming solution?

Thanks

Not sure, Lee. If they need to make more than one selection, you'll need a
listbox in VBA. If just one, then no VBA is needed. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com


"Lee" <Lee@discussions.microsoft.com> wrote in message
news:FDE5E117-5129-4C00-8AB0-66F0877759FE@microsoft.com...
> How do you set up a pick box in a cell.
>
> What I want to do is when you go to cell, let say G4 I would like to open
> a
> pick box or list that would have names in it to pick from. And, can I edit
> the contents of the box.
>
> would this be a programming solution?
>
> Thanks

You could use data validation to create a dropdown list in a cell, and
it doesn't require programming. There are instructions in Excel's Help,
and here:

http://www.contextures.com/xlDataVal01.html

Lee wrote:
> How do you set up a pick box in a cell.
>
> What I want to do is when you go to cell, let say G4 I would like to open a
> pick box or list that would have names in it to pick from. And, can I edit
> the contents of the box.
>
> would this be a programming solution?
>
> Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html