View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Validation Table - Entering Value not in a table

DataValidationError Alert

Uncheck "show error etc."


Gord Dibben MS Excel MVP

On Thu, 21 Aug 2008 11:15:03 -0700, saltnsnails
wrote:

I have a Validation table on my timesheets that my employees record a
pre-entered activity from a validation table to decribe what they did during
a certain time frame. From time to time, there will be special exceptions
that the employee needs to enter a value that is not in the validation table.
Is there a way to have a cell in the validation table that will accept data
entry that is not present in the table?

Thanks!