Check out DataValidationAllowList.

Put your names in a list and use the fropdown arrow to select a name from the
list.


Gord Dibben MS Excel MVP

On Sun, 17 Jun 2007 19:34:00 -0700, kb wrote:

hi..im need 2 add 2 option buttons.. i have 2 cells that are for placeing a
persons name ( to eliminate and error due to misspelling of a name)..i want
to place 2 option buttons ..and place that persons name in the cell and use
the option button instead of haveing the name typed in
Thanks in Advance