Populating a worksheet

[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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

Assume a single column Listbox

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