I think we need some more information. Where is this list of possible
entries at... In a declared VB array? In a range of cells? In a String
variable? Somewhere else? Also, what do you mean by "the already entered
value of an array"... is that an array of cells or a declared VB array?

--
Rick (MVP - Excel)


"Wullie" wrote in message
...
Hi,

I am going round in circles as usual and am doing (at least) one stupid
thing with a lack of logic, so need some help.

I have a list of possible entries that someone can manually enter, which I
then want to check against already entered values of an array and then if
it's not in the array to add it to the next value of the array (up to 4
values).

Can someone please assist me with this or point me in the right direction?

Thanks