option buttons help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Gord Dibben said:
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



Gord..thanks for reply..but.
Click to expand...
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
setting up option buttons 1
OptionButton with Bookmark text output 1
Option Buttons that use macros 3
Access Create option group without using wizard? 2
Oversensitive touchpad on modern laptops 0
Excel Is this possible?? 3
How can print A Id badge From a Excell Work Sheet 3

Back
Top