Macro for prompting date entry

[Armored Wing]

Hi all, I need to create a condition in which a input prompt pops up for date entry.

I have two problems currently present in my spreadsheet. The first one is that i need to have the message of the equation

Please Login or Register  to view this content.

displayed in the cell upon fulfilling the condition followed by the prompting of entry of the date.

The second problem I currently face is that I can't seem to get the date format to display in the input box as it only displays numbers.

Please Login or Register  to view this content.

If anyone could provide some help to where I went wrong, that would be greatly appreciated.

[Kelshaer]

Your first problem is not clearly described.
For Your second problem use the following code instead

Please Login or Register  to view this content.

[Armored Wing]

All right I have uploaded the sheet that I am currently working on. First, the second code worked so I want to thank you Kelshaer. My first problem now is that when any cell becomes "pending" in column F, I would like the date entry code to execute corresponding to the cell that become pending (so if cell F10 became pending, A10 would pop up the date prompt), otherwise the code won't execute at all. I hope that help clear up some confusion anyone might have.

[Kelshaer]

Here you go

Please Login or Register  to view this content.

[Armored Wing]

I tried it out but the prompt does not pop up when pending display in F? Am I missing something?

[Kelshaer]

Its working for me
Please find the attached file

[Armored Wing]

Ok the macro does work on the active row and cell but is that a way to make it automatically appear the f column being turned into pending? Since I still have to double click it in order for the box to show up.

[Kelshaer]

If you mean to make it launch without considering which column was double clicked then use this:
Although i dont recommend it this way as you might double click any other column to enter data.

Please Login or Register  to view this content.

[Armored Wing]

I guess what I want is that instead of double clicking, the moment that the cell F10 becomes pending, the cell in A10 will automatically prompt the user in entering a date which will display in cell A10. I don't know if that is feasible or not.

[Kelshaer]

Hope this will work

Please Login or Register  to view this content.

[Armored Wing]

It auto opens now but now an error message displays the run-time error 1004 with the range being the object that failed.

Please Login or Register  to view this content.

[Kelshaer]

So Sorry, My mistake.
Here is it:

Please Login or Register  to view this content.

[Armored Wing]

Please don't apologize for the errors, I just wish I was better at VBA so I can complete harder tasks. However, I am extremely grateful for your help, but I was wondering if you could help me out with one last thing. Using the code that you wrote, now I have to apply it to my finalized spreadsheet in which the columns which are pending will automatically prompt the user. I tried the code out but was unable to get the box opened. I will upload the finalized sheet for your reference.

Once again, I am extremely grateful for your help.

[Kelshaer]

Try this one

Please Login or Register  to view this content.