Populating a worksheet
 

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!

Populating a worksheet
 

Assume a single column Listbox

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

--
Regards,
Tom Ogilvy

"Audrey Ng" wrote in message
...
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!