Posted to microsoft.public.excel.programming

Forum freak $at work$ $Forum freak $at work$ is offline$

external usenet poster

Posts: 12

Is this number validation possible?

Hi

I need to validate the contents of a cell based on the following.

It must be a 5 digit number.
The 5 numbers can only be 1,2,3,4, & 5
Each number can only be used once.

This will be a test included in a macro however could it be done by formula?

Any help would be appreciated.

Kenny W
Using XP Pro and Excel 2003

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Validation of UK VAT Number	Rob	Excel Worksheet Functions	24	October 18th 13 05:25 PM
validation for phone number	Candice	Excel Discussion (Misc queries)	3	April 28th 06 08:51 PM
attach a label to number, like validation but follows the number	Rickster	Excel Worksheet Functions	0	February 2nd 06 08:58 PM
Whole Number Validation in Input Box	Dkt24	Excel Programming	3	April 11th 05 08:22 PM
Number Validation	Tim	Excel Programming	5	February 6th 04 02:19 PM

All times are GMT +1. The time now is 02:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us