adding multiple columns to a listbox
I have a UserForm with various ComboBoxes and Labels. At the click of a
CommandButton, I would like to add these items to 7 different columns in a
listbox. The comboboxes and labels will then go blank to be filled in again
and when the CommandButton is clicked again the list box adds another row
with the new items, and so on.
Do I have to use an array for this or just additem/list. Please help.
|