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
|