once cell E1 is entered need input box for date to be populated in B1

I am somewhat new to VBA and did not find anything in a search so thought I would try this question. Once I enter data in cell E1 I would like an input box to ask for a due date. Once the due date is entered I would like it to be put in cell B1. I would also like the date to be formatted as such, mm/dd/yy 12:00 PM. Thank you to anyone that can help. It is greatly appreciated.

Right Click on your sheet name at the bottom of excel and select view code.

Paste this code there

Close Visual Basic.

Please Login or Register  to view this content.

Thanks for the response, however I am getting a "Compile error: Ambiguous name detected: Worksheet_Change." I do have other code in the worksheet and I suspect it needs to be somehow within the rest of the code. I also would like to have this input box open for every line in the worksheet from line 1 on. Sorry I didn't mention that earlier. I have attached a snapshot of my code. Thanks for the help thus far.

Code.JPG

Ok

Insert this line into your existing Change Worksheet Code

Please Login or Register  to view this content.

Ok

Insert this line into your existing Change Worksheet Code

Please Login or Register  to view this content.