fill combobox

Good evening,

I start over with what simpler.

I want to fill a combobox on a form thats get its data from sheet1 collumn A. But its new so there is no data in Coloumn A. i entry in the combobox data that wil store in sheet1 Colomn A -row1.
and so on


Combobox value = emty (becourse i made no entry yet)
Combobox entry is 1 ,sheet1 coloumnA row1 = 1
Combobox value = 1 ,entry is 2 ,sheet1 coloumnA row2 = 2
Combobox value = 1 and 2 ,entry is 1 Sheet1 coloumnA row3 = 1
here it comes
Combobox value now = 1 and 2 and 1 so i have a double value it`s 1

question : how i stop double values in combobox and i can entry data in combobox but sheet1 coulumA will unchanced
Knipsel.PNGKnipsel1.PNG

when i have a piece of code for this hten the rest i figure out myself .

greetz Tankje(Rob)

comment deleted

Here is a bit of code that will populate the comboBox with unique values

Please Login or Register  to view this content.

Unique.jpg