VBA textbox to edit rowsource of listbox specific column

I am looking to amend a certain column in a listbox which also edits the data on the sheet from a text box.

I have attached a basic sheet with a userform. I want textbox1 to edit the first column in the listbox and textbox2 to edit the second column in the listbox. currently textbox1 edits both columns

bump.......

Hi,chrismccarthy

try this

nice This is awesome

Originally Posted by simcode

Hi,chrismccarthy

try this

Perfect! Thank you!

Fancy helping me with another thing which is going into the same workbook? it's a quick and I know it but cant seem to crack it

Sorry, I'm not clearly about your question.

Simcode you good in-here, nice of you