PDA

View Full Version : Combo box Duplicates



Svmaxcel
10-04-2017, 12:49 PM
I created 3 combo box to list the items.
Created Name Range as Item1,Item2,Item3.

Used code on userform initialize to load row source as Item1.

Userform.Initialize
Item1.rowsource = "Item1"

When I run the form, I am able to see all items listed in Item1.
But the items are duplicated.
Example :
Laptop appears 5 to 6 times and same with desktop.
I want it to be displayed only once.
Also wanted to link Item2 and Item3 based on Selection.
In short, depended combo box as per the condition.

Please let me know how to remove duplicate and create dependent list.
File attached.

mdmackillop
10-04-2017, 12:59 PM
Code, Userform and Comboboxes as missing from your workbook.

Svmaxcel
10-04-2017, 08:40 PM
I am not at work as had week off.
This sheet was created using mobile.

Svmaxcel
10-05-2017, 02:09 AM
eed help in coding UserForm
Form attached

I need some inputs from Worksheet and after that when I fill the form, want details to be filled in Worksheet
Looking at attachment, you will understand what I want


I get huge data in which we have rating from 1 to 4
I will put the data in Raw sheet and I want that it should automatically filter 1 and 2 ratings rows and copy it in the main sheet
There should be no duplicate in Main sheet.
So everytime I put the data in raw sheet, I want it to filter the new one and add it to Main sheet

In main sheet there is a column named Audits.
I want the userform to start when any row in column Audit has been clicked.
User form should display info like name, I'd, manager, customer number based on the row user has clicked.
Once the form is filled I want Audit column to be as Yes.

mdmackillop
10-05-2017, 02:52 AM
This is not a free coding service. Post your code and let us know what your issues are.

mdmackillop
10-08-2017, 05:22 AM
Crosspost https://chandoo.org/forum/threads/help-with-userform.36004/