Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

with multiple option buttons on my form how do I isolate groups

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sabrina - 17 Sep 2007 20:40 GMT
I created a form with the option button feature from the forms toolbar. I
have them grouped for different questions selections,but it won't isolate for
each group it will only select one for the whole worksheet. I need them to be
able to do one selection for each question.
Peo Sjoblom - 17 Sep 2007 21:02 GMT
Are you using the groupbox for each set of buttons?

Signature

Regards,

Peo Sjoblom

>I created a form with the option button feature from the forms toolbar. I
> have them grouped for different questions selections,but it won't isolate
> for
> each group it will only select one for the whole worksheet. I need them to
> be
> able to do one selection for each question.
sabrina - 17 Sep 2007 21:18 GMT
Here is an example
1.)    (inserted option button) Approved
       (inserted option button) Pending              
        (Inserted option button)Rejected

2)     (Inserted option button)Received
       (Inserted option button)In progress
       (Inserted option button)Not Received
The issue is that I have these all over my worksheet but when someone goes
to select an option it will only select one for the whole worksheet, when I
need to have it select one for each question (group) throughout the worksheet.
                           

> Are you using the groupbox for each set of buttons?
>
[quoted text clipped - 4 lines]
> > be
> > able to do one selection for each question.
Peo Sjoblom - 17 Sep 2007 21:52 GMT
You need to use the group box to make them independent of each group, it's
in the same forms toolbar, just grab a hold of it with the mouse and drag it
around the 3 option buttons,  do the same for all of the groupings.

Signature

Regards,

Peo Sjoblom

> Here is an example
> 1.)    (inserted option button) Approved
[quoted text clipped - 21 lines]
>> > be
>> > able to do one selection for each question.
sabrina - 17 Sep 2007 22:06 GMT
Got it, thank you, I knew it was something easy.

> You need to use the group box to make them independent of each group, it's
> in the same forms toolbar, just grab a hold of it with the mouse and drag it
[quoted text clipped - 25 lines]
> >> > be
> >> > able to do one selection for each question.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.