Thread: how do I create drop boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
  
Posts: 1,758
Default how do I create drop boxes
I think the easiest way may be data|validation and then =vlookup() in that other
cell.

Debra Dalgleish describes both at:
http://www.contextures.com/xlDataVal01.html
and
http://www.contextures.com/xlFunctions02.html

Terry wrote:

I have been trying to create a drop box that when, Example: when I select
"Brick" that will generate a number 7 in a cell that will be calculated by a
nother cell.

--

Dave Peterson
Reply With QuoteReply With Quote