Posted to microsoft.public.excel.worksheet.functions

Dan[_7_]

external usenet poster

Posts: 3

Data Validation of user input

I need a function to text user input. The input must be 10 characters in
length, consist of 5 digits, 1 letter and then 4 digits (a property barcode).
Examples:
00015D6345
01451A0011
Any other format will get an error message.
Can someone help me?
--
Dan

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
Data Input Validation	Mark S[_2_]	Excel Discussion (Misc queries)	5	February 24th 08 12:00 AM
Incrementing Data based on user input	learningaccess	Excel Discussion (Misc queries)	3	January 26th 07 03:28 PM
Excel + user input + external data (URL manipulation)	[email protected]	Excel Discussion (Misc queries)	2	September 28th 06 05:48 PM
User Data Input	DRANDON	Excel Worksheet Functions	0	June 30th 06 08:12 PM
Asking for user input if there is no data for the function	elitewolverine	Excel Worksheet Functions	0	October 13th 05 09:17 AM

All times are GMT +1. The time now is 06:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us