I have to load a large amount of data into a listbox control on a userform. This is a list of patients in a clinic so the final number of rows on the worksheet containing the data will reach tens of thousands. (I know Excel may not be the best tool to use, but it is the only option available to me at the moment).

Because the patient list grows constantly through the day, I have been simply assigning a name to the entire columns that contain the data I need (only two at the moment) and setting the rowsource as this named range. This loads very quickly, but the blank area at the bottom of the listbox looks poor.

Is there a way to quickly load a 2 column x (say) 30000 row range of data into a listbox so that only calls with data are included or should I continue as I have been?

Thanks in advance

Peter