user form initiailising incorrectly

**james1965** · 06-12-2012, 11:54 AM

Hi

I have a user form that is used to input data from feedback forms. This is pre-populated with set answers from a drop down list eg question 1 score yourself 1,2, 3 or 4 or question 2 the answer is either yes or no y or n

There are several pages and at the end teher is a save button that saves the responses into a spreadsheet and then restarts the form back at the first page.

When the form is opened initially by the command button the drop down lists are populated correctly.

However when the save button is used, the first page has the drop down lists duplicated. eg 1,2,3,4,1,2,3,4,. y,n,y,n,

This does tend to create errors when you try to tab through the form.

Any ideas what programming is creating the duplicate drop down list?

The attached document has screen shots and the programming from VB

The save button is Command button 16

Thanks in advance

James

**protonLeah** · 06-12-2012, 04:58 PM

What's the purpose of posting pictures of forms and copies of Excel macros as text in a Word document?
Why did you not post the Excel workbook instead?
No one is going to try to recreate and troubleshoot it for you.

**JosephP** · 06-12-2012, 05:39 PM

I'd guess you are running code that uses additem to populate the controls but you are not clearing the control first. add a combobox1.clear for example at the start of the code.