View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
davidm davidm is offline
external usenet poster
 
Posts: 1
Default USE OF DROPDOWN in Combobox-a problem


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