Editing data in userform and transferring back into row it came from

Hi All,

I have a masssive lot of VBA coding to do and am fading fast. I have been tasked with creating a 'database' of project data (from two departments), in Excel using VBA with multiple Userforms. There are three spreadsheets 1) one with project data info on, 2) main spreadsheet that all userforms transfer their data too, 3) spreadsheet of all completed projects. Users will add and edit data.

I have so far through searching the internet and reading been able to create all userforms for entering and editing data. I am currently seeking help in transferring ListBox data to spreadsheet, but I also need help with how to edit data pulled out of a spreadsheet into a userform - edited by the user (including ListBox entries), and then transfered back into the row it came from.

I using the below coding to pull what data I can so far from spreadsheet. But there are two things i need to find out/know please. 1) how do I pull data from a spreadsheet into a listbox and change it in a UserForm 2) how do I then transfer all this UserForm data back into the row of the spreadsheet it came from. I am really struggling as there is so much code out there, and my brain is nerly full.

Please Login or Register  to view this content.

Many thanks

If I may make a couple of suggestions:
1. Please use code tags when posting code. It's more legible and is actually one of the forum rules.
2. Please post a sample workbook. It's not at all clear, at least to me, what exactly you have and what you want. This code appears to populate the same controls in a loop and I can't see the point of that.

Just use excels find, record a macro doing it, then look at the code, searching for your textbox value.