Hi there,

I would like to fill my listbox with all the column headers (excel).

I am wondering if any of these would work

1) Using a SQL statement to retrieve all the column headers into the listbox

2) loop to last cell within the first row (excel takes 1st row by default to be column names) and additem to listbox at each loop.. i'd use a range to specify the first row/cells... so that i can refer to the individual cells using an integer.

my loop will just consist be restricted to x=x+1 till end of last filled cell.

Kindly advise which method is viable? Anyone has examples to share? Thank you very much@