Thread: pull down menu
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default pull down menu

Ben

Data Validation will do the trick.

For info and instructions see Debra Dalgleish'a site.

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben Excel MVP

On Mon, 2 Feb 2004 08:04:00 -0800, "ben"
wrote:

I am entering data into a field and would like a cell to
contain a pull-down menu to select from. For example on a
certain cell it would have a little arrow on the side and
then you could choose option 1, option 2, etc... Does
anyone know if this is possible?