I have simple list box on one of the sheets of an Excel (not on a userForm).
I want to add two column of information. I set the multi-column value to 2.
How can I add values to 2nd column?
Adding values to first column works fine such as:
lstTest.list = array("a","b","c")
but, adding value to second column doesn't work:
lstTest.list(0,1) = array("a","b","c")
And, I noticed that RowSource property is not there either, any one know why?
Thanks,
Afzal
Bookmarks