View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ana Paula Ana Paula is offline
external usenet poster
 
Posts: 4
Default Selec the column to add in a listbox

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