(Userform) Display data depending on selected sheet

Hi everyone,

I have a userform that is launched when clicking on the edit button (it only serves the purpose of editing). The data is located on several sheets (A, B, C). When selecting a sheet in the combobox, I would like to be able to see the data of each sheet (I have only managed to do so for sheet A). When selecting the row, I can enter the new name and save it.

I have issues with displaying the data depending on sheet selected and the save button that changes the name (it leads to an error).

Can someone help me?

Thank you in advance for your time.

Thank you, this works fine !