Thanks Bruce. Using *Private Sub UserForm_Activate()* in place of the
Initialize event did the trick. Not for the first time, I am confounded
by the nuances between these two events. Does it seem safer to use the
Activate event in all cases?
Ross:
The list occupies the top left-hand corner of the worksheet, completely
sheared off the userform. I believe if you run my code (using Initialize
event)you will find the same result.
David
--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread:
http://www.excelforum.com/showthread...hreadid=558308