Date Entry error In Microsoft Excel 2000
 

Hi ,

When I am trying to enter a date previous to the current date and any future
date in an excel template which is having macros running.For eg If i give a
current date the template will work and will go into the worksheet.But when I
tried to give any previous date or any future date it is giving a "DATE ENTRY
ERROR" and the template is not working at all.

I tried to check the short date in the control panel and made the date
settings as dd/mm/yy format and tried for the template.Still it is allowing
only for the entry for the present date.No user can enter any previous date
and any future on the template.xls.

Please suggest the solutions as early as possible.This is very URGENT for me

Thanks and Regards

Date Entry error In Microsoft Excel 2000
 

I could be way off base here, but it sounds to me like Data Validation. Try
looking at Data Validation, and see if anything there strikes you as
unusual or unnecessary.

Here is some documentation for DV:
http://www.contextures.com/xlDataVal01.html#DataVal01

Regards,
Ryan--


--
RyGuy


"Binu Gopal" wrote:

Hi ,

When I am trying to enter a date previous to the current date and any future
date in an excel template which is having macros running.For eg If i give a
current date the template will work and will go into the worksheet.But when I
tried to give any previous date or any future date it is giving a "DATE ENTRY
ERROR" and the template is not working at all.

I tried to check the short date in the control panel and made the date
settings as dd/mm/yy format and tried for the template.Still it is allowing
only for the entry for the present date.No user can enter any previous date
and any future on the template.xls.

Please suggest the solutions as early as possible.This is very URGENT for me

Thanks and Regards