Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data validation causing problems when using a data form in Excel 2 | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |