option box cell link

A

AWilderbeast

Hi i have a option box problem. I am making a questionnaire and the
answers are selected with option boxes then a right or wrong answer is
given back. My problem is that the cell link for the option boxes is
all the same and when you change 1 of the option boxes links they all
change. Also it wont let me pick more then 1 option. How can i solve
this?

Thanks
 
B

BrianB

"It is a feature, not a bug" <grin>.

I think you will have to use check boxes instead
 
J

Jim Rech

I assume you're talking about Forms toolbar option buttons placed in a
worksheet. If so use a Group Box to create sub-groups of option buttons.
 
D

Dave Peterson

And if your optionbuttons come from the control toolbox toolbar, then rightclick
on each and change the GroupName property.

Each Group gets its own unique Groupname.
 

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

Combo Box & If formula 1
Two sets of option boxes? two separate reference cells? 2
option buttons / group box 1
Linked cells and text boxes 2
Interactive Data Input Boxes 6
dialog box selection type 1
Copying List box values/selection to a database of sorts 2
Forms Check Box cell link 4

Top