Vba script

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:02 PM GMT

Question

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...


Answer

Advertisement

©2021 eLuminary LLC. All rights reserved.