PDA

View Full Version : [SOLVED] Add new record in spreadsheet



thombill
05-19-2005, 01:10 PM
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
05-19-2005, 01:20 PM
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