Option Button on Sheets?

  • Thread starter Thread starter jordanctc
  • Start date Start date
J

jordanctc

I am experienced with option buttons on forms but what I really need i
to use is option buttons on a sheet. I have inserted 3 options button
on a sheet (Option Button 7, Option Button 9, & Option Button 10) - wha
I would like to do is...

* rename the buttons 7-Inside, 9-Outside, & 10-Both (I can do this)

* have a cell display the label of the selected Option Buttons (hav
not figured this one out yet)

Thanks,
Jorda
 
By the names, these look like you used the option buttons from the Forms
toolbar.

Maybe you could use a linked cell (rightclick on one of them and choose
format control|control tab|cell link

I used A1 in my test.

Then I used a formula like:

=IF(A1=0,"",CHOOSE(A1,"7-Inside","9-Outside","10-Both"))

To return the choice.
 

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

option button groups interact with eachother 1
Analyzing Results of a Survey Using Option Buttons 2
Using Option Buttons from the "Forms" Menu 5
Use and navigate through option button on w/sheet 4
Excel Option buttons 3
Help! Cannot select option buttons when Excel sheet is protected. 1
Synchronize option button 7
delete option buttons 2

Back
Top