option buttons help
 

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

option buttons help
 

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

option buttons help
 

"Gord Dibben" wrote:

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

Gord..thanks for reply..but.
i have 20 different times that i have to select the correct
cell(person)..and i would like it to b visible what cell (person) has been
selected..becaue i have macros that are running IF statements .according to
the cell selected thats why i want option buttons .. pluss its clearly
visible who was selected..
so if u could help with options buttons .that would be great
thx KB