Vba script

QuestionEdit

I am using2000 version and would like a script for a userform which if I click on commandbutton1 it will copy listbox1 to the next empty cells in column A of the active sheet. i.e. there is already data from A1:A20 therefore it will copy the listbox data from A21:-A whatever depending on how many values are in the listbox if 50 lines then it would copy to the next 50 available cells in column A etc...

AnswerEdit