Code required to accept today date.

[sachin.tiple]

Hi Folks,

I am new to VBA programming and i required one code which will allow me to update only todays date in particular cell in that cooumn and once the date has been entered it will save as value so that next day it will not change the date.

Aprreciate your help.

[DonkeyOte]

One way...

Please Login or Register  to view this content.

[sachin.tiple]

Thanks for quick reply donkeyote,

However i want this code to run at back end and when any user try to enter previous date in particular cell lets say "E345" then it should not allow him to do so.

Actually this is to track the daily activity and to maintain data integrity.

[DonkeyOte]

Have you thought of perhaps using Data Validation? http://www.contextures.com/xlDataVal06.html

I'm not really sure I understand the workflow you are trying to implement in this instance...

[sachin.tiple]

Dude thanks for reply.

If the user copy the previous date then the validation will remove from tht cell and it will accept. however if user will type the date then will not be able to do tht validation will show an error to user.

So please guide me if there is any other alternative

[D_Rennie]

Please try

Please Login or Register  to view this content.

1st part will put the current date into cell A1.
2nd part will, when a user trys to select the cell A1 it will select the cell to the right.
Note this is not 100% fool proof though may do the trick.
Adjust the ranges to suit.

[D_Rennie]

Reread your question.
DonkeyOte's code for the 1st part is what you want,
The code i provided will update the date each time the sheet is activated.

[sachin.tiple]

hi D_Rennie

Actually the way i want the data i like
A B C D E
1 sachin EX DB 21/8/2009

There are 5 colums and in 5th i.e "E" coloums user has to enter the current date. sometimes he forgot to put the data in sheet then he will come next day and put the previous date. that is wht i want to restrict the user to use previous date. so that user can fill the daily actvity sheet regularly and on time. this may help me to do right analysis wht my user is doing.

I guess u got it wht i want to convey. so please help me user are furging the data and i cant track tht.

[D_Rennie]

you lost me completly in the last post.

IF you have someone that forgets to do his job on time, though comes in the next day and backdates it. WHY do you want to restrict it to only allow todays date. If they are forgetfull the system will fail.

Or are what you saying you want to restrict him/her from only being able to use todays date or yesterdays date. so then you can see if they are 2+ days behind.
If this is the case you are probely better off using data validation on each cell in that row.

[sachin.tiple]

Hi, D_Rennie

I can use data validation for date however when i copy paste the previous date then it will accept the change.

SO PLEASE GUIDE ME.

[D_Rennie]

Ok i see where you are comming from now.

Try
Put this in the worksheet code section.

Please Login or Register  to view this content.

Change the range to suit.

Hope that helps