Stop duplication in a combo box

[10121730]

hi,
below is my code which i have for a drop down list within my userform...
i have been asked to select a name from a listbox then use the combo box to select a "mr" "miss" etc to them show up together in a label.

the problem i have is that every time i click on the drop down it duplicates the list that is already there,,
could someone please advise of a way to stop this

thank you

Please Login or Register  to view this content.

[mikerickson]

Put that code in the Userform_Initialize event.
It will run once and the list will always have those 6 items in it.