Radio Buttons - Values

A

adidas12121

Good morning,
I have an old workbook ( Developer no longer with the company ).
He has a collection of four radio buttons gathered in a cell
ex: Row 11, Columns G, H, I, J has four buttons
Button 1 text = Excd
Button 2 text = Meet
Button 3 text = DNV
Button 4 text = N/A
If I select one of the buttons, a value gets populated in cell K11.
ex: Excd returns a 1, Meet returns a 2, DNV returns a 3, and N/A returns a 4.
My question is... how do I edit the values or even see the values.
I'm able to see that all four buttons cell link = $k$11 on the Control Tab
of the Format Control window... but I cannot find where the values are stored
or assigned.
A BIG thanks in advance for any feedback.
Have a great day,
Joe
 
L

Luke M

They aren't "assigned", they're defaults. Excel gives a value to control
tools based on selection (combo box, radio buttons, scroll bars) with 1 =
first choice, 2 = second choice, etc. In a way, its similar to how the MATCH
function returns the relative position of a word within an array.

However, knowing this, you can then use these values in a seperate formula
to generate desired values. For instance, you could setup a small lookup
table with 1-4 in first column, and desired output values in return column.
Then base your lookup off of the linked cell and table to get desired value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top