This is my first post here so apologies in advance if I'm doing anything sacreligious. I did try searching first, and although I think it must have happened before I couldn't find anything relevant.
I have a userform with a 'Clear' command button (with the cancel property set to True) so that a user can clear a form half-way through and start again.
Private Sub cmdClear_Click()
The procedure it calls is as follows (there are more boxes but I assume it not necessary to show anything more than an example):
Private Sub UserForm_Initialize()
.AddItem "Full-time resignation"
.AddItem "Full-time recruit"
.AddItem "Part-time resignation"
.AddItem "Part-time recruit"
cboMovetype.Value = ""
After the Clear button is used, the form is reset and returns to the first combo box but the problem is that the options in all the combo boxes are duplicated, e.g. the first four are shown and then repeated underneath. This recurs every time it is pressed. I'm sure it must be something quite obvious but I can't see it. I copied most of this from another bit of script which works so I am mystified.
Help would be gratefully received.