Validating & Error checking function
 

I have an excel worksheet:

ID Date Company
Transaction_Code
001 10092007 LG Electonic
000124
002 11092007 Acer Computer
000354
003 11092007 Value System Inc.
000224
004 12092007 Dexty Consultancy
000324
-------------------------------------------------------------------------------------------
My Questions:

I'd like to consturct validating functions for each cell:

- If i input more than 3 digits in the column "ID", there should pop up a
warning

- If my Data format is incorrect (anything other than "ddmmyyyy"), it
should pop pup a warning or something



- Or is there any other way to do it ?
- Any suggestions ?


Thank you so much ^_^!




--
Allen Phailat Wongakanit

Validating & Error checking function
 

Once again see your other post

"ali" wrote:

I have an excel worksheet:

ID Date Company
Transaction_Code
001 10092007 LG Electonic
000124
002 11092007 Acer Computer
000354
003 11092007 Value System Inc.
000224
004 12092007 Dexty Consultancy
000324
-------------------------------------------------------------------------------------------
My Questions:

I'd like to consturct validating functions for each cell:

- If i input more than 3 digits in the column "ID", there should pop up a
warning

- If my Data format is incorrect (anything other than "ddmmyyyy"), it
should pop pup a warning or something



- Or is there any other way to do it ?
- Any suggestions ?


Thank you so much ^_^!




--
Allen Phailat Wongakanit

Validating & Error checking function
 

Dear mike,

what if i want to have 2 (or more) validation rules for each cell ?

is that possible ? and how am i able to do that


big thanks first, you're the expert ! ^_^!


--
Allen Phailat Wongakanit


"Mike H" wrote:

Once again see your other post

"ali" wrote:

I have an excel worksheet:

ID Date Company
Transaction_Code
001 10092007 LG Electonic
000124
002 11092007 Acer Computer
000354
003 11092007 Value System Inc.
000224
004 12092007 Dexty Consultancy
000324
-------------------------------------------------------------------------------------------
My Questions:

I'd like to consturct validating functions for each cell:

- If i input more than 3 digits in the column "ID", there should pop up a
warning

- If my Data format is incorrect (anything other than "ddmmyyyy"), it
should pop pup a warning or something



- Or is there any other way to do it ?
- Any suggestions ?


Thank you so much ^_^!




--
Allen Phailat Wongakanit