Maybe you could keep track of the list of names in a range on a hidden sheet.
Then you could use application.match() to see if the proposed name already
exists.

Gizmo wrote:

I have a user form that has a cell for entering name. I want to be able to
enter data using a dropdown or type in a new value that gets added to the
dropdown. I do not want to see duplicates in the dropdown.

--

Dave Peterson