PDA

View Full Version : Solved: multi dim listbox used to populate cells?



wolf.stalker
05-21-2011, 10:11 AM
hi all and thanks for any assitance you can provide!

basiclly, i have a list box that is 4 columns wide by a max of 8 rows deep.

Once i popluate the the list box, i will then need to move the data from the list box onto another sheet.

So i need help with writting the code to do the move. i am not sure how to access each specific item in the list box.

any help you could provide would be great!

thanks again

wolf.stalker
05-21-2011, 10:42 AM
ok, i think i might have stumbled upon the solution...

frm2New.ListBox1.AddItem "Row Number 1"
frm2New.ListBox1.List(0, 1) = "Column Number 2"
frm2New.ListBox1.List(0, 2) = "Column Number 3"
frm2New.ListBox1.List(0, 3) = "Column Number 4"