Listbox on Userform not transferring data

I would really appreciate the help. Thanks in advance!

Attached is a picture of my userform for a visual reference. My issue is having three options to choose from on my userform to be selected and have the information be transfered into my master sheet. This is the code I have for the form currently but the only information that transfers is the "Manually entered" text box. Any suggestions?

Userform1.PNG

ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 1).Value = ListBox1.Text

ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 1).Value = ListBox2.Text

ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 1).Value = TextBox3.Text

ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 2).Value = ListBox3.Text

ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 2).Value = ListBox4.Text

ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 2).Value = TextBox16.Text

ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 3).Value = TextBox4.Text

I'll need to de-sensitize it in order for me to post. Can I clarify any questions? I'll work on another workbook in the mean time.

Thank you for your response.

They reference the same column because I need to have the option to select one of the three options, and then have that data be entered into the column. Does that make sense?

This may clarify my original question. I want to be able insert my data from either the listbox or the textbox. My code isnt allowing me to do this.

Please Login or Register  to view this content.

Mike - this works great! Thank you very much!