Transfer listbox and textbox data from userform to spreadsheet

Hi All,

I am really, really stuck - i hope someone can help me please. 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.

I have so far through searching the internet and reading been able to create all userforms for entering and editing data. The userforms consist of TextBoxes and ListBoxes. I am able to transfer the TextBox data into the main spreadsheet when a 'save' button is clicked, but I cannot find the coding I need to transfer the text from the ListBox in the userform to the same row as the TextBox is going into. This is the coding I have for the TextBoxes to be taken across, saved and returned to the 'main menu'. The ListBoxes are in the code also, but do not go across. Listbox options are populated by 'With' codes and not RowSource. Can someone point me in the right direction please?

Please Login or Register  to view this content.

Ahhh, thank you Mehmetcik - I did not know or realise that. Maybe it will be easier to re-write this to how you have said. Thanks for your help.