View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_197_] Rick Rothstein \(MVP - VB\)[_197_] is offline
external usenet poster
 
Posts: 1
Default 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