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.

Option Button HEEEELPPP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gia S. - 19 Sep 2007 15:36 GMT
After two hours of figuring out how to get one of those cute option
buttons...I don't know how to add a value to the buttons.  Example I need one
button to be worth 4 and then I need them to add all up at the end.  Most of
the butttons are worth the same thing so I dont know if I have to have a new
data cell for each one.  Please help.
Peo Sjoblom - 19 Sep 2007 15:45 GMT
Maybe you can explain what you are trying to do? You realize that options
button are what their names say so if you click one the other are
deselected. So I don't understand how you are going to add them.

Signature

Regards,

Peo Sjoblom

> After two hours of figuring out how to get one of those cute option
> buttons...I don't know how to add a value to the buttons.  Example I need
[quoted text clipped - 4 lines]
> new
> data cell for each one.  Please help.
Gia S. - 19 Sep 2007 16:18 GMT
I'm trying to create a sheet that calculates how many credits you have versus
how many needed in completion.

For Each class I have 3 options

Say the class is Chemistry.  it looks something like this.

Class Name          Completed           In Progress           Not Complete  
   Needed

Chemistry             Option Button       Option Button        Option Button
         
                           (Worth 4)              (Worth 4)            
(Worth 0)               4

Biology                  (Worth 3)              (Worth 3)             (Worth
0)               3

*If they selected Completed for Chem but Not complete for Bio

Total Credits              4            /                          /        
                 /         3

I have to have 3 options even if one is worth 0 because it's also used as
their checklist for graduation.  So It has to be Printable.    

> Maybe you can explain what you are trying to do? You realize that options
> button are what their names say so if you click one the other are
[quoted text clipped - 8 lines]
> > new
> > data cell for each one.  Please help.
 
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.