Yes, I meant close the workbook completely. If I were to set the
RowSource property, where would the best place be to place the code?
Workbook_open, initialize? Anyway, RowSource wasn't shown in the
properties window but ListFillRange was and I used this with the
values located in the worksheet. That works fine, is it the same
thing? (I'm using Excel 2000.)

Thanks,
Derek

"Bob Phillips" wrote in message ...
Derek,

What do you mean by close the sheet? Do you mean you close the workbook
completely? If so, the listbox will not have those values as it will be
re-initialised upon opening the workbook. What you would need to do is put
that code into the Workbook_Open event, so that it is automatically loaded
each time. Either that, or put the values in a worksheet range, and set the
RowSource property to point at that range in the control design.