You could also do this with a dynamic list instead of re-setting your
validation routine(s) every time you add a name to the list.

Like so,

Say you have R1-R26 as your range, define the following as a named range

myRange =OFFSET(R1, 0, 0, COUNTA(R1:R$65536), 1)

then set your Cell's validation = List and set to myRange.

What myRange is now - a list of everything non-blank in Column R. If you
add values to the end of the list, anything that references this range will
automatically show up in the validation list.

I have a number of dynamic ranges in several applications that do this.
(Easiest to have a hidden worksheet that holds these values.)

Hope this helps,
Chad



"rammieib" wrote:

Hi

I cannot find this in the groups anywhere.

I would like to update a validation list, which is in cells "FR2" to
"FR26" which contains a list of names. I would like a user to be able
to click on a button which pops up with a message saying "Enter New
Buyer Name", they enter the name, click ok and then the validation list
has been updated in alphbetical order with that persons name.

Could someone help me with the coding for this pls.

Thanks in advance.

roger