creation of message box as per mentioned condition

Thanks a lot Dave. Yes, my code was not "Ok". Just one small doubt, when we select "yes" its a new project then E2 & F2 cell are getting cleared. But I have simply linked other cell in other sheets with this E2 & F2. As an example, A2 & B2 Cell of Sheet2

=Sheet1!E2

&

=Sheet1F2

& similarly... Now when I select "yes" these linked cells are showing "0" & date & time "1/0/1900, 00:00".

Is there any solution?

Originally Posted by ss_bb_24

Thanks a lot Dave. Yes, my code was not "Ok". Just one small doubt, when we select "yes" its a new project then E2 & F2 cell are getting cleared. But I have simply linked other cell in other sheets with this E2 & F2. As an example, A2 & B2 Cell of Sheet2

=Sheet1!E2

&

=Sheet1F2

& similarly... Now when I select "yes" these linked cells are showing "0" & date & time "1/0/1900, 00:00".

Is there any solution?

When you have a 0 in a cell formatted for date and time it will become 0 days and 0 hrs because that is how date works.
Todays date, 11/20/08 in fact is 39772 days from 0 hrs 1/0/1900 and 39772.25 would be 11/20/08 6:00 AM .25 being 1/4 of a day.
Enter =now() in a cell and you will get the present date and time, change that cell format to general and the number displayed is the number of days from zero hour, 1/0/1900, the decimals being a portion of a day that gives us time.
With that being said.

This if statement would work.

=IF(Sheet1!F2="","",Sheet1!F2)