How to make a new table based on selected result in listbox

  • Thread starter Thread starter Kortrijker
  • Start date Start date
K

Kortrijker

Dear all,

I'm testing an userform, there are two listboxes in it. I can make user move
fields name from left listbox to right listbox, by using

ListBox2.AddItem ListBox1.Text

but I don't know how to continue,

because the result I want to realize is, based on added items in listbox2,
my datatable would ONLY show those fields whose name is shown in listbox2
(in the beginning, there are 'name', 'age', 'class', 'score' and 'comments'
in the table, for instance, if only 'name' and 'age' are shown in listbox2,
the table would only show recorders in 'name' and 'age' fields), I'm
thinking to delete fields whose name isn't shown in listbox2.

Would you give me some suggestion?Thanks.

JIANG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to delete unselected columns in a table, thanks 2
how to work with all items in a listbox 1
Sorting a listbox when items are added 4
Alert if value is already in listbox 2
Listbox Output to Individual Listboxes 1
Any more effective method to get selected item in Listbox? 3
userform listbox cannot get listbox.value to transfer back to main sub 1
Go to sheet based on ListBox selection 5

Back
Top