How can i write code in visual basic using Match?

[coolbreeze858]

Is match the best option to do this?

I have 3 cells C17:C19 and dont want repeated data, in them.

Im using a drop down list to get the values, there is also 3 values in this list.

can someone please simplify there answer right down as i have limited knowledge.


Is there a way in which I can limit the cells to only allow the 3 values (red, white or mixed) from it's drop down list, by using vb code.

Can someone display the written code, if i can understand it better, thats what will get the best answer. thanks

Hope someone can help thankyou

i have a drop down box, but i want to limit, the cell. if you copy and paste, into the cell the error message is not detected, i want to write some VB code in Excel's VB Descriptor.

[Peter K]

I'd store the data in an associative array. In this way duplicates are automatically eliminated. In VB associative arrays have a type name "Collection".