Populating a worksheet

  • Thread starter Thread starter Audrey Ng
  • Start date Start date
A

Audrey Ng

Hi all,

I am a newbie to Excel VBA. I have a userform with two listboxes.
Listbox A is populated from Sheet 3 of the Excel spreadsheet. ListBox B
GETS populated by selecting members in ListBox A. How would I then
populate whatever is in ListBox B back onto Sheet 1 (in a column)?

Hope this makes sense,

Audrey
 
Assume a single column Listbox

With Worksheets("Sheet1")
.Range("A1").Resize(ListboxB.Listcount,1).Value =
ListBoxB.List
End With
 
Back
Top