#1   Report Post  
Ian Shere
 
Posts: n/a
Default "RADIO BUTTON"

I have written a spreadsheet (mostly) but am stuck on how to set up radio
buttons. I have 6 main categories each of which have 4 sub categories. The
user is to select ONE sub category of each main category. I want to assign a
numberical constant to each radio button then have Excel add them up to give
me a total.

The adding up (once I have values) is easy (obviously) but I have no idea on
how to set up the radio buttons, assign a constant to them or extract that
data. I assume that each set of buttons within each main category needs to
be grouped (not sure how to do that either) so that they work as a unit.

Am I asking way to big a questions here? Like is this a days worth of
tutorial??!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I lock a radio button group if a N/A button is selected worry a lot Excel Discussion (Misc queries) 2 May 21st 05 08:33 PM
how do I link radio button selection to another page Sharon Excel Worksheet Functions 0 April 27th 05 09:29 PM
How do I set up a radio button on an Excell spreadsheet Mikel Excel Discussion (Misc queries) 1 April 7th 05 03:57 PM
Can't remove Radio Button Ken G. Excel Discussion (Misc queries) 2 January 17th 05 05:38 AM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Excel Worksheet Functions 2 October 29th 04 07:06 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"