View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amy Stein Amy Stein is offline
external usenet poster
 
Posts: 2
Default Setting Max Value

I have a worksheet with a range of cells that have a SUMIF function
based on entry into another range of cells. How can I prevent user
entry that will cause these cells to exceed the value of 10?


Thanks in advance for any help.


Amy