option buttons help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kb - 18 Jun 2007 03:34 GMT

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

Reply to this Message

Gord Dibben - 18 Jun 2007 04:47 GMT

Check out Data>Validation>Allow>List.

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

Gord Dibben MS Excel MVP

>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

Reply to this Message

kb - 18 Jun 2007 23:06 GMT

> Check out Data>Validation>Allow>List.
>
[quoted text clipped - 10 lines]
>
> 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

Reply to this Message