software

HELP Please! I have created checkboxes (Y/N) in from the forms tool bar. I am
trying to be able to only select 1 box at a time. When I tried using the
option buttion it worked but, I need buttons in other places on the
worksheet. When I copy and paste the option button I still cannot just select
1 at a time. I am just learning about macros and am not good at it yet.
Hope this makes sence.

Thanks

You need to GROUP you option buttons that you only want to have one selected
at a time. Example, you can have four option buttons on the same worksheet.
Button's 1 and 2 can be grouped and button's 3 and 4 can be grouped.
Therefore, either button 1 or 2 can be checked AND either button 3 or 4 can
be checked. To group option buttons you use the group box control on the
forms toolbar. No macro is required to set this all up.

Hope this helps.

Bill Horton

quot;KBquot; wrote:

gt; HELP Please! I have created checkboxes (Y/N) in from the forms tool bar. I am
gt; trying to be able to only select 1 box at a time. When I tried using the
gt; option buttion it worked but, I need buttons in other places on the
gt; worksheet. When I copy and paste the option button I still cannot just select
gt; 1 at a time. I am just learning about macros and am not good at it yet.
gt; Hope this makes sence.
gt;
gt; Thanks

Thank you that did it. 1 more questions, I am trying to have 2 option
buttions in a single cell which I have done, my questions is: how can I keep
them both from showin selected? Is this at all possiible?

quot;William Hortonquot; wrote:

gt; You need to GROUP you option buttons that you only want to have one selected
gt; at a time. Example, you can have four option buttons on the same worksheet.
gt; Button's 1 and 2 can be grouped and button's 3 and 4 can be grouped.
gt; Therefore, either button 1 or 2 can be checked AND either button 3 or 4 can
gt; be checked. To group option buttons you use the group box control on the
gt; forms toolbar. No macro is required to set this all up.
gt;
gt; Hope this helps.
gt;
gt; Bill Horton
gt;
gt; quot;KBquot; wrote:
gt;
gt; gt; HELP Please! I have created checkboxes (Y/N) in from the forms tool bar. I am
gt; gt; trying to be able to only select 1 box at a time. When I tried using the
gt; gt; option buttion it worked but, I need buttons in other places on the
gt; gt; worksheet. When I copy and paste the option button I still cannot just select
gt; gt; 1 at a time. I am just learning about macros and am not good at it yet.
gt; gt; Hope this makes sence.
gt; gt;
gt; gt; Thanks