View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rowan Drummond
 
Posts: n/a
Default How to create a menue bar of numbers in a cell?

Not sure about a "menu bar" but you could use data validation to provide
a drop down of choices for the cell value. See
http://www.contextures.com/xlDataVal01.html

Hope this helps
Rowan

DORI wrote:
Is it possible to have a cell with a menue bar so that when I click on it, a
range of numbers or text choices appear so I can pick up the one I need to
assign to that cell?
Thanks,
Dori