View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sue[_6_] Sue[_6_] is offline
external usenet poster
 
Posts: 6
Default Excel Data Validation

Hi there

I wish to prevent certain values (eg: the words "Expenses", or "Exps")
from being entered into a cell...they can enter any other
description/words they like (up to say, 40 characters), I just don't
want them to be able to enter either of those mentioned above....how
do I do it? VBA?

The data validation function is just not cutting the mustard, but it
may be I'm overlooking something simple...?

thanks in advance - really appreciate any help
Sue