Textbox data update in selected row

Hi,
I have used a programme and here in Data sheet and working on M, N and O column.
First I have used a form in textbox 1 if will type “pending” all the pending list opened in listbox based of O column. And when click it the required data opened in textboxes but when I am putting date in Textbox6 or Textbox7 it will update in the second row only instead of the selected row.
Secondly in O column will update Clear when M & N both column cells get filled and it will show keep pending if any one is blank. Request to see where I stuck. Thanks.

Thank you both the Sirs. I have used Bakerman sirs code because here date format is exactly updating in sheet. Cysu sirs date is update just opposite in sheet like when i am typing 04-05-2025 (04-Apr-2025) it is updating 05-04-2025. Rest all are ok.
One small query here. When text box is populating here the first row date is also shown opposite. I need it will show as exactly mentioned in sheet like dd-mmm-yyyy format. Please have a look at this.

Dear Josh Sir your work tried and works fine. Only need two small changes there.
1. Need header in listbox at the time of populate data
2. Column M and N will be empty and i will put date time to time and when i have added or edited date with changes date format like "dd-mmm-yyyy" it is updating like 05-04-2025 instead of 05-Apr-2025. I need date formula dd-mmm-yyyy in every date place. Thanks.

John Sir superb. All the code is working super fine. Thank you very much to provide total solution in this regard.

Dear John Sir,
Sorry to trouble again. I have go an error in the attached file.
First when i deleted all the data in M and N column and click a record in listbox it will shown an error and in list box it is highlighted in yellow

Please Login or Register  to view this content.

Secondly when i will put a date in textbox6 it will update in M column without given any error and it is not mandatory to fill both textbox dates at once in 6 and 7.
Request your help in this.

Thanks Mike Sir. Now listbox is not given any error but at the time of put date in textbox6 it will give error. But data uploaded. I want data update without any error. If will fill both textboxes i.e. textbox6 and 7 it is not showing error but only filled of textbox 6 and click on command button showing error.

Thanks Mike Sir for your help but the code is running when i have filled both the blank textboxes. if i will put date in textbox6 and click on Submit then it will show message and not updated. I want the date will fill either to put a single date and another date may be filled later.

Mike Sir. now it's fine. No error. Smooth running. Thank you very much..