View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default using check boxes

You can also group option buttons.

If they are from the forms toolbar you can group them within a frame.

If they are from the control toolbox, they have a Group property which you
can set.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hell-fire" wrote in message
...
Thank you Bob,

I would like to use option buttons, but I have 15 different sections to
use
the yes/no and other select type fields. When I try to link each set of
option buttons to a particular cell, all the option buttons link to the
same
one. Is there a way to have each options button set link to different
cells.

"Bob Phillips" wrote:

Why not use optionbuttons, that is a property of optionbuttons
implicitly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Hell-fire" wrote in message
...
Hi,

Sorry for such a newbie question and probably one already asked. I
have a
form that I made and in some cells, I have check boxes for yes and no.
I
know how to link the check boxe to other cells that will later be used
as
field data to be imported to access.

What I need to know is how to set a formula, so when you check yes, you
won't be able to check the no box and vice versa. Is this possible?
Thank you.