Put input into a cell in file

[sulavsingh6]

Hi, I am trying to prompt excel to ask for a date if a cell C3 is empty. And then I am trying to place the value entered into cell C3.

my code is as follows:

Please Login or Register  to view this content.

Thanks for your help

[Leith Ross]

Hello sulavsingh6,

This will enter the date and verify it is a valid date. If it is not a valid date, the user is notified and asked again to input the date.

Please Login or Register  to view this content.

[sulavsingh6]

thanks that worked. I have a quick question though. Is there a way to make sure that the code runs instead of having to run the macros manually everytime. Right now after the prompt comes up and you enter a year it displays the year. If you then delete they year the prompt does not show up again.

thanks

[excel_1982]

Maybe try putting the code in sheet chage event and check if the target is the cell that has been changed. If so call the method again.

[sulavsingh6]

Thank you very much. That did it.