Hi all,
when I press the clear button on my user form it repopulates the
combo box list when I press the clear button.

For instance when I operate

Private Sub cmdClearForm_Click()

Call UserForm_Initialize

End Sub

It adds the same information again to my drop down lists. i.e I have 5
names, when I press the clear button once, I get ten names, this is
repaeted ad infinitum.

What am I doing wrong?

excel 2003 all updated on WinXP PRO

Thank you all.

ALan.


--
alann2
------------------------------------------------------------------------
alann2's Profile: http://www.excelforum.com/member.php...o&userid=37531
View this thread: http://www.excelforum.com/showthread...hreadid=572580