If you're using the combo box from the Control Toolbox, you could use an
event procedure to update the list. For example:

Private Sub Worksheet_Activate()
Me.ComboBox1.ListFillRange = _
ActiveWorkbook.Names("MyList").RefersToRange.Addre ss
End Sub

There's information about application events at Chip Pearson's site:
http://www.cpearson.com/excel/AppEvent.htm

bach wrote:
The first instances of the sheet will be blank, the user then gets data
via a macro and from then on data is always present.

Or could it be done in VBA using the control drop-down list object.

Bach.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html