Add new record in spreadsheet

[thombill]

What I have done is created a Userform with a list box of facilities. I want to populate a spreadsheet in the active workbook with the information selected in the listbox. I know how to get the data into the list box and I know how to get the data into the spreadsheet say A2, upon closing the userform. How do I get the userform to add the next data selected in the userform to A3 etc....:banghead:

[Bob Phillips]

What I have done is created a Userform with a list box of facilities. I want to populate a spreadsheet in the active workbook with the information selected in the listbox. I know how to get the data into the list box and I know how to get the data into the spreadsheet say A2, upon closing the userform. How do I get the userform to add the next data selected in the userform to A3 etc....

Do you mean something like?



iNextRow = Cells(Rows.Count,"A").End(xlUp).Row + 1
cells(iNextRow,"A").Value = Listbox1.Value