Help with Radio buttons

Posted by Russell on November 20, 2001 7:29 AM

How do I put a radio buttin on a cell? Everytime I insert a radio button into my worksheet, it wants to "float". Is there a way to put a radio button in the cell or do I have to link the cell to the button? And if so, how do I lilnk the button to the cell? And how do I repeat that for every column in a cell?

Sorry for so many questions, but Microsoft doesn't provide very usefull info on this subject.

Thanks in advance,
Russell

Posted by Juan Pablo on November 20, 2001 7:33 AM

With the "Forms" toolbar, click the Radio Button, then press [Alt], and drag in the cell where you want the Radio Button to be, it'll cover it completely. Then, right click it, choose Control Format, Control and in the Linked Cell choose one from any sheet. If you link a couple (or more) to same cell Excel will recognize them as a "group", and the Cell will show the number of the radio button that was selected.

Juan Pablo

Posted by Russell on November 20, 2001 7:49 AM

Thanks for the quick response....but......

Thanks for the quick reply, that works for what I am trying to accomplish, but how do I get one radio box to associate with only one cell. In a nutshell, what I am trying to do is make a checklist. I am trying to set questions, based on a yes or no answer, that will report information from other columns in the same row. For example, I am working on an inventory control list to post to the web. One of the questions will be "Was a picture taken?" (column N) - Radio button yes or no. If no, then the report will give the information of the stock number (column A) on a new worksheet.
Am I on the right track with this, or should I be looking for a diferent method.

BTW, I know nothing about MAcros, but think I know enough about array formulas to post the data from one cell (based on a condition - i.e. 1 or 0) to another worksheet.

Posted by Juan Pablo on November 20, 2001 7:53 AM

Re: Thanks for the quick response....but......

Well, i don't think that's the best use for radio buttons... i'd rather go with Check Boxes (True or False in one check box), or even easier, Data Validation, select the cell you want to have "Yes" or "No", go to data, validation, select List, make sure that "Show drop down" is activated, and put

Yes,No

You can even copy this cell to others where you want to do the same thing... it's easier than with CheckBoxes (because you won't have to set each specific CB with their own linked cell)

Juan Pablo

Posted by russell on November 20, 2001 7:59 AM

Re: Thanks for the quick response....but......

Alrighty, I'll give that a wirl - I was trying to get to complicated.....typical :-)

Thanks again for your help

Russell