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.


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=401881