software

I was attempting to use checkboxes to format different selections in my
worksheet, select one then the other option is deselected, etc. I was not
able to find a way to do that using checkboxes, so, I searched here and found
the Option button.. option. The issue I have with Option buttons is, that
when you create multiple options in different locations the on/off option
affects all option buttons in the worksheet. i.e. selection category 1,
option a , b. selection category 2 option a , b. When you select option 1a
the other three option buttons are blanked. How can I separate the fields
into individual entities. Using Checkboxes (preferred), or option buttons.

Any help would be greatly appreciated.

If right click on the option button and select properties, and in the list of
properties locate GroupName. Assign the buttons to specific group names and
when a selection is made only a button belonging to that group is deselected.

--
Kevin Backmannquot;JW_4222quot; wrote:

gt; I was attempting to use checkboxes to format different selections in my
gt; worksheet, select one then the other option is deselected, etc. I was not
gt; able to find a way to do that using checkboxes, so, I searched here and found
gt; the Option button.. option. The issue I have with Option buttons is, that
gt; when you create multiple options in different locations the on/off option
gt; affects all option buttons in the worksheet. i.e. selection category 1,
gt; option a , b. selection category 2 option a , b. When you select option 1a
gt; the other three option buttons are blanked. How can I separate the fields
gt; into individual entities. Using Checkboxes (preferred), or option buttons.
gt;
gt; Any help would be greatly appreciated.

Yes sir, that did it !

Thank you for your help.

quot;Kevin Bquot; wrote:

gt; If right click on the option button and select properties, and in the list of
gt; properties locate GroupName. Assign the buttons to specific group names and
gt; when a selection is made only a button belonging to that group is deselected.
gt;
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;JW_4222quot; wrote:
gt;
gt; gt; I was attempting to use checkboxes to format different selections in my
gt; gt; worksheet, select one then the other option is deselected, etc. I was not
gt; gt; able to find a way to do that using checkboxes, so, I searched here and found
gt; gt; the Option button.. option. The issue I have with Option buttons is, that
gt; gt; when you create multiple options in different locations the on/off option
gt; gt; affects all option buttons in the worksheet. i.e. selection category 1,
gt; gt; option a , b. selection category 2 option a , b. When you select option 1a
gt; gt; the other three option buttons are blanked. How can I separate the fields
gt; gt; into individual entities. Using Checkboxes (preferred), or option buttons.
gt; gt;
gt; gt; Any help would be greatly appreciated.