OLDie but NEWBIE... Match data from combo box to another sheet in excel

I have a user select combo box D21 on sheet1 named Input populated from Column A on sheet2 named Data containing "mm/dd/yyyy hh:mm:ss". I want to have a text box at F24 on sheet1 (Input) that I can type in a date, then click a cmd button and have it preform the following function:

Have the vba code to find the exact mm/dd/yyyy hh:mm:ss in column A on sheet2 and place the date from F24 (sheet1) to column "I"(sheet2) on the same row of where the exact mm/dd/yyyy hh:mm:ss was found in column A(sheet2), if empty.
If a date already has been entered in column I, have a message box to confirm to replace it or cancel.

Thank you all for any time and help for my inquiry.




Have a pleasant tomorrow, by having coffee today!

Give this a try:

Please Login or Register  to view this content.

Thank you for your skill and knowledge. I believe I should have said, Enter a date in cell F24 instead of using the reference {(I want to have a text box at F24 on sheet1)}. As your code that is written is looking for a TextBox1. Thank you again for any help.

I am a little confused now. I think you are saying that you just want to use the date entered into cell F24 on the "Input" sheet:

Try:

Please Login or Register  to view this content.

Thank you, Sir! PERFECT!

Ok, I'm not sure what happened, but I'm attaching the file. It doesn't seem to be working now. The date in Input!F24 isn't accepted and it will not search for a exact match from Input D20 within column A on PartsData. And it doesn't copy the date to the Date completed column after the match is found on PartsData Sheet. TOTALLY CLUELESS........

Thank you for all your time invested! The only reason I wanted to use mm/dd/yyyy hh:mm:ss format was so I could select it in the combo box d20 (I mistakenly identified it as d21)and use it as reference for an exact match PartsData!A:A in order to enter a date completed on the correct row of column J. I realize that initially I said column I, but after needing to add more information to the DB, I will have to add more columns. I thought I had a few brain cells left which I could tweek it in order to make your solution work.........obviously not!

I believe this should fix your problem:

Please Login or Register  to view this content.

Yes sir, it does!