Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Daryl Butler   on Mar 18 In MS Office Category.

  
Question Answered By: Tyrell Thompson   on Mar 18

The quick and dirty method is to use the listbox  property called RowSource.
You are able to assign the address of your list to that property and the
listbox will list the values in your table. The only downside is that if
the dimensions of the list change you have to remember to go update the
RowSource property.

The not as quick version is to use the worksheet or userform's activate
event to loop through your list and use the AddItem method of the listbox to
add all the items in the table. As long as the loop is dynamic, the list
will always display the values in your table  even if the number of rows
change.

There are other options, but these two should get you what you need.

Share: