Thread: data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
clara clara is offline
external usenet poster
 
Posts: 252
Default data validation

Hi all,

I have input area on my sheet as following :

Item1
Item2
Item3
Item4

each of them sittin on one cell, I would like users to input from item1 to
item4 and I did it by using formula, but after input users can also erase
item1 and make a blank cell about item2. How to prevent it?

Clara

--
thank you so much for your help