View Single Post
  #1 (permalink)  
Old August 4th, 2007, 10:46 PM
zone zone is offline
Authorized User
Join Date: Jul 2007
Location: , , .
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data Validation and format

1) How could I force user to enter data (Date) in this column (Cell-) ACC-DATE) like exact same format.
2) If user keep blank in first column they will be prompt to put data in ACC-DATE cell in dd/MON/YY format.

ACC_DATE BATCH_NAME Amount1 total1 total2
-------- --------- ------- ------ -----
02-MAY-07 Batch 1 10.00 10.00 10.00
03-JUN-07 Batch 2 20.00 20.00 20.00

3) Users are not allowed to enter data into next cell/row until they enter date.
Kind of message box type will be a great to do I guess.

(Date can not be null and can not be other then dd/MON/YY format.)

Feedback’s are greatly appreciated.

**How can I lock the total1 and total2 column using macro/VBA?