View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
joel[_12_] joel[_12_] is offline
external usenet poster
 
Posts: 1
Default Data entry for fixed cell ranges


You could use in the Data menu Validation - List. You can put in the
List a range of cells or a list of differrent strings. This will create
a drop down list for your selection.

Remember that you want to be able to remove an item if put data into
the wrong cell.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=144058