View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Morgan Paul Morgan is offline
external usenet poster
 
Posts: 13
Default Loop through userform

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