Userform Edit function help Please

Hi all,
I have been greatly helped by Fotis1991.
This question is an extension of my previous question.
I should have made a fresh thread. Apology for the mistake.
It will not happen again.

I need help in the following aspect please.

The code works fine, only thing that it does not edit existing records.
I have attached so far created workbook.
It has 3 sheets named 'New' , 'Inuse' and 'Finished' + 1 userform with two textboxes.

It does retrieve the existing records from sheets as selected... in list box.
However does not edit existing records . It only creates new record.
I am aware that it will need a row reference to replace existing records, but I dont know how to do it.

Once again help by Fotis1991 is greatly appriciated.
Please help.

Many thanks
Kind regards

Hi Tinbendr,
Many thanks for your kind help.
Example is simple and understood.
I would really appriciate if you can help in my original sample file with a code so that everything will be in one place and easy to understand for me.
Kind regards

Hi again,
I agree with you.
The userform sample, we are successful in getting data into the userform.
However when I edit it & submit, it goes as a new entry rather than edited version of existing entry.
Please refer my sample book userform.xlsm
Thanks a lot again.
Please help
I have spent many sleepless nights to get this right, but not yet successful.
Thanks

Hi

Please Login or Register  to view this content.

Please refer to see history.
Many thanks

Hi ,
Do you need any more information please
Kind regards

Hi Friends,
I am bit confused.
What do we do next now to find solution.
Please advice.
Kind regards

Hi Foits1991 & Tinbendr,
Ideally combining codes of Fotis1991 ( Get data in list box)
And Tinbendr's code to edit them will be ideal.

What happens if we have 27 columns to deal with.
Tinbender's solution is really good but is limited to one column or so to say one textbox only.
Therefore recalling records in listbox and then selecting them by clicking , will populate userform.
This then can be edited

Hope for the best
Kind regards
This is what I am looking for

Hi,
I have modified the code of Tinbendr,
And tried to adapt concept of Fotis1991.
Few things work few don't.
Needs some fine tuning.
Please help
Kind regards

Hi Tinbendr,
Thanks
Actual data is either a text or number ( very simple)
Yes 27 columns in one sheet.
want to load all records from sheet1 and columns A,B,C,D to list to pick from. ( And it loads all records in respective textboxes )
So I click on command button to open form, then pick record from list.
Amend it and save it.
OR create new record

Greatful
Kind regards

OK sir.
Will do

Hi Tinbendr,
Yes indeed. Very well done. Very very close indeed
Still there is a compiling error for the command button code happens:

Please Login or Register  to view this content.

Hi
The code highlighted states ' end with without with,
I tried to understand and code looks ok
I don't know what's the issue
Many thanks
Kind regards
😀

Hi Tinbndr,
Very well tried Sir,
Something is not right
Now the following line gets highlighted.

Please Login or Register  to view this content.

I will certainly never give up.
I will take ahead your great efforts to the right conclusion.
May be I am using excel 2010 and certain codes may not work correctly I guess.
I will get back to you.
Once again very well done to you
Kind regards

Sorry,
Tinbendr
Name was incorrectly spelled.
Apology