Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a new table based on selected result in listbox
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make copy of workbook based on selected criteria | Excel Worksheet Functions | |||
how do i get excel to use data in a table based on the result of a | Excel Worksheet Functions | |||
Create interactive pivot table chart based on item selected | Charts and Charting in Excel | |||
How to make a table with only one cell to be selected? | Excel Discussion (Misc queries) | |||
How to make a table with only one cell to be selected? | Excel Discussion (Misc queries) |