Form ComboBox problem
 

cmpcwil2,

Forgive me if I have misunderstood your problem. But as a quick
response off the top of my head try replacing...

Ddown.Text = myDD.List(1)

with...

Ddown.ListIndex = 1

HTH,
Nick.

Form ComboBox problem
 

Thank you works fine, why didn't I think of that!


--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=534962