Question description:
This user has given permission to use the problem statement for this
blog.
Hi, quick question about the following situation:
So I have 4 yes/no radio buttons all in 4 different group boxes. I am trying to make it so that if I select yes for one of them, cell B2 populate "high", and if I select yes for two of them then B2 populate "medium", and if I select yes for none of them or for any 1 of 4, B2 populate "low". Which radio buttons selected are irrelevant, but it matters as to how many of them are selected. If I can get advice on how to code this that would be nice. Thanks.
Solved by O. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
01/12/2017 - 10:33
Hi
User
01/12/2017 - 10:33
hi!
User
01/12/2017 - 10:33
how are you
Excelchat Expert
01/12/2017 - 10:34
So so, so do you have a file to work on?
User
01/12/2017 - 10:35
um well yea but can u help me based on the description?
User
01/12/2017 - 10:35
cause the spreadsheet might be confusing
User
01/12/2017 - 10:35
I just need help on that area
Excelchat Expert
01/12/2017 - 10:35
I hope so
User
01/12/2017 - 10:35
it's like area by area
Excelchat Expert
01/12/2017 - 10:35
Ok let me check
User
01/12/2017 - 10:36
ok thanks!
User
01/12/2017 - 10:36
I know it might be bunch of if/else statement
User
01/12/2017 - 10:37
but I'm not surehow to assign the radio buttons in the if/else statement..
User
01/12/2017 - 10:39
do I have to assign an individual macro to each of the 4 radio buttons first so I get their macro names? and then use those macro names in the if/else statement for the whole ? not sure if that's possible..
Excelchat Expert
01/12/2017 - 10:39
May be so , let em try
User
01/12/2017 - 10:39
okok
User
01/12/2017 - 10:40
ok ok*
Excelchat Expert
01/12/2017 - 10:55
https://www.dropbox.com/s/c9docem8z1p6qj8/High_Low.xlsm?dl=0
Excelchat Expert
01/12/2017 - 10:56
So far this what I did, I ahve not assigned a code
User
01/12/2017 - 10:56
oh ok
Excelchat Expert
01/12/2017 - 10:56
And it is working on serieally, means if you select the first one
Excelchat Expert
01/12/2017 - 10:56
low will pop up
Excelchat Expert
01/12/2017 - 10:56
Second low
Excelchat Expert
01/12/2017 - 10:57
third High
User
01/12/2017 - 10:57
oh ok
User
01/12/2017 - 10:57
I mean there should be 8 buttons
User
01/12/2017 - 10:57
4 yes radio buttons
User
01/12/2017 - 10:57
4 no radio buttons
User
01/12/2017 - 10:57
and they come in couples
User
01/12/2017 - 10:57
so 4 group boxes
Excelchat Expert
01/12/2017 - 10:57
Ok
User
01/12/2017 - 10:57
each has a yes radio button and no radio button
User
01/12/2017 - 10:57
yea
Excelchat Expert
01/12/2017 - 10:58
So if A group has yes
Excelchat Expert
01/12/2017 - 10:58
Then low
User
01/12/2017 - 10:58
and if I select yes for any 2 of the 4 sets
User
01/12/2017 - 10:58
right
User
01/12/2017 - 10:58
or if all no
User
01/12/2017 - 10:58
then it's low
Excelchat Expert
01/12/2017 - 10:58
ok let me workout
User
01/12/2017 - 10:58
but if two of them are yes, any two, then medium
User
01/12/2017 - 10:58
ok thanks
User
01/12/2017 - 10:58
yea sry for the confusion
User
01/12/2017 - 10:58
if 3 of them are yes, any 3, then hihg
User
01/12/2017 - 10:58
high
User
01/12/2017 - 10:58
that's it
User
01/12/2017 - 10:59
oh sry not three
User
01/12/2017 - 10:59
oh yea three yea sry lol
User
01/12/2017 - 10:59
that's the situation
Excelchat Expert
01/12/2017 - 10:59
ok let me think and work
User
01/12/2017 - 11:01
sure
User
01/12/2017 - 11:01
thanks again
User
01/12/2017 - 11:32
everything ok my friend?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
