View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
starguy starguy is offline
external usenet poster
 
Posts: 1
Default Using validation to block cells


I have provided a solution for this, please look at my previous post.

RiotLoadTime Wrote:
Ray,

I understand that that will make my drop-down box with those four
options (1, 2, 3, N/A), but with it block the input user from filling
in any of the cells in the same row if "N/A" is selected?

Thanks,
-RiotLoadTime



--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=569856