Thread
:
"RADIO BUTTON"
View Single Post
#
2
Bob Phillips
Posts: n/a
Answer in public.excel
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Ian Shere" <Ian
wrote in message
...
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 With Quote