Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a list in a sheet with 20 columns and a use a listbox to check the
datas in this list, for exemple: A B C D E F.... Numb Name Tel state code e-mail Validation code when i want check all the datas, i use the code below to add all the column in the listbox ListBox1.ColumnCount = 20 ListBox1.RowSource = "A4:T200" But sometimes I need check just the datas in some columns, so what i want to do is insert a commandButton that when the user press this buttom just apears in the listbox the columns B, D and F. is it possible? please someone can help? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create multi choice selec drop down list in Excel please | Excel Discussion (Misc queries) | |||
excel shuts down bringing up file having multiple worksheets selec | Excel Discussion (Misc queries) | |||
Macro to capture cell value then use it for a relative range selec | Excel Programming | |||
A recorded Macro to hide certain selected columns hides non selec. | Excel Programming | |||
To have an entire row highlighted to some color if any cell in that row is selec | Excel Programming |