Populating userform word boxes based on listbox selection

Hi

I am new to VBA and am struggling a little.
I have a workbook that is functioning as a database. I already have a userform for data entry that writes data to an 18 column spreadsheet. What I am stuck with is some kind of edit function. I have a listbox on a userform that is populated from one column of the spreadsheet as a dynamic range. I would like to be able to make a selection from the listbox, then populate the first userform with the corresponding data for the selectiono to allow this to be changed and then re-writen.

Thanks

Easier to help if you send me your file is partially finished!

Hi

Apologies, that is obvious now. Here is the file.
Thanks
T

It is now the lifeguards drowning case. I can not see woorsheets on the screen. Help me if you get air!

I think the main issue has been resolved.
Looks like there are still problems to be solved in the file.
After a few days I'll have time to deal with it.

Thank you very much, nice solution, do you think there is anyway of displaying the names in the list box and selecting one of them instead of a cell on the spreadsheet?

Thanks again.

If the name of the person guaranteed only occurs once, then the answer is yes. Anyway the thing is ambiguous.

I suggest the followin:

It is possible to display all the rows in the WorkSheet("Datadb") and choose to edit the row on the basis of this.

Then write back the modified row in the table in the WorkSheet("Datadb")

So if i understand your meaning display all information from Worksheet("datadb") in the listbox, be able to select and populate wordboxes and then write modified row back to worksheet. That's be great, any help would be appreciated. Thanks.

I am trying to reduce access to data in datadb due to number of users inputting and editing data.

Thanks for all your help.