Radio Button

[mberesh]

What I'm looking to do seems logical (and simple), but I'm missing something when it comes to how to use radio buttons.

I have a list of 10 items, call them A through J. I want to put a radio button next to each and when a button is checked (only one can be checked at any given time), a 1 appears in the column next to the associated radio button. Whenever I create a second radio button, it always seems to link to the same cell. I need each subsequent radio button to link to the next cell down the list (i.e. one radio button linked to Item A, one linked to Item B, etc.). In other words, the first radio button links to cell A1 (item A), the next links to A2 (item B), etc. Then I can create a lookup in another tab to see which cell has the 1 in it and pull back the relevant information.

How the heck can I do this? What am I missing?

 

[NBVC]

You have to put each radio button within its own group.

So select group then insert a radio button, then select a new group and insert new button, etc... Then you can link separate cells.

 

[mberesh]

Thanks for the really prompt reply, NBVC. Still need a little assistance.

If in different groups, then multiple radio buttons can be selected at the same time. I want to ensure that only one radio box can be selected at any given time AND the radio buttons each link to a different cell. Any thoughts?

 

[NBVC]

I'm not sure that can be done so straightforwardly.

But what you can do is use if statements, to get your results.

So if you group is linked to Cell A1, which not directly next to the group itself.

Then in the cells next to the group add a statement in each, like:

=IF(A1=1,1,""), for first cell
=IF(A1=2,2,""), for second
=IF(A1=3,3,""), for third

And so on... get my drift?

 

[mberesh]

Yeah. I don't think it's going to work though. If ever somebody adds an 11th item and inserts it in the middle (it is sorted alphabetically), that would throw all the numbers off. Not a big deal, I will use a check box and will create an error message if more than one is checked. Thanks anyways.

 

[NBVC]

Sorry about that