Populating a worksheet

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
 
T

Tom Ogilvy

Assume a single column Listbox

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inconsistent dir() behavior 1
Populating a listbox from an excel column 2
Listbox Problem 1
clearing cells when selecting values from different listboxes 0
Listbox displaying incorrectly on opening worksheet 3
Use VBA to Populate Listbox from Open Spreadsheet 4
Possible to have only one value in a listbox 1
Run-time 438 - OptionButton troubles 4

Top