If you load all the data into the listbox initially (you can hide any columns you don't want displayed), then you can simply access the List property of the listbox directly to assign any column to another control, rather than having to access the worksheet again.