Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
option buttons | Excel Worksheet Functions | |||
Option Buttons | Excel Discussion (Misc queries) | |||
Using 'Option Buttons' | Excel Discussion (Misc queries) | |||
Option Buttons | Excel Discussion (Misc queries) | |||
yes/no option buttons | Excel Discussion (Misc queries) |