Loop through userform
ListBox'es have a Clear method which will remove the items in them. For
example,
ListBox2.Clear
should remove all the items in ListBox2.
Rick
"Paul Morgan" wrote in message
...
I have a userform with 7 ListBoxes
6 listboxes are populated by the selection made from ListBox1(some
ListBoxes do not get populated all the time)
How can I clear(reset) ListBoxes 2 to 7, because some selections will
populate all the list boxes and some will only populate 1 or 2
listboxes, if a selection is made that populates all the listboxes,
then another is made that only populates 1 listbox, the other
listboxes are still populated because of not being cleared(reset)
Thanks
|