using check boxes
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. |
using check boxes
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. |
using check boxes
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. |
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. |
using check boxes
Thank you Bob, that works
"Bob Phillips" wrote: 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. |
All times are GMT +1. The time now is 09:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com